Hi all,
I have a sheet that contains fields for "Preparer Due Date" and "Preparer Status" and am trying to add in the following logic to a formula:
Return "Blue" if status is "completed"
Return "Green" if task is in process and is due more than 3 days away
Return "Yellow" if task is in process and is due within the next 3 days
Return "Grey" if task is not started and is due more than 3 days away
Return "Red" if task not started or in process that are past due
Preparer Due Date Preparer Status Formula
7/1/2021 Not Started Gray
7/1/2021 In Process Red
7/1/2021 Completed Blue
7/29/2021 Not Started Yellow
7/29/2021 In Process Yellow
7/29/2021 Completed Blue
8/10/2021 Not Started Red
8/10/2021 In Process Red
8/10/2021 Completed Blue
Thanks in advance!
Bookmarks