Update Status and Progress of an activity based on Actual Start and End Date
I am relatively new to smart-sheet and would require assistance in setting up formulas for my POW Sheet .I would like to have my status column of an activity to be updated based on the actual start and End Date
- Start Date = Blank Status to be updated as Not Started (Red)
- Start Date is not Blank and End Date = Blank ; Status to be reported as In Progress (Amber)
- Start Date= Not Blank and End Date = Not Blank ,Completed .(Green)
Appreciate assistance with the same
Help Article Resources
Check out the Formula Handbook template!