Hello, helpful people.
I'm working in Google Sheets and I'd like to achieve the following:
In case it matters:
Thanks ?
I'm working in Google Sheets and I'd like to achieve the following:
- If G date is blank, show text "In Progress" in H
- If G date is before F date, show text "Complete" in H
- If G date is blank and F date has passed, show text "Overdue" in H
- If G date has passed F date, show text "Late" in H
In case it matters:
- I've used the following formula to fill each row in amber/green/red/green for in progress/complete/overdue/late respectively: =$H$1:$H$999="Complete"
- Column H (Status) is using data validation for 'in progress'/'complete'/'overdue'/'late'
- I have alternating colours on (grey/white, as shown in the screenshot)
Thanks ?
Last edited by a moderator: