Update Status and Progress of an activity based on Actual Start and End Date

Hi ,

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

  1. Start Date = Blank Status to be updated as Not Started (Red)
  2. Start Date is not Blank and End Date = Blank ; Status to be reported as In Progress (Amber)
  3. Start Date= Not Blank and End Date = Not Blank ,Completed .(Green)

Appreciate assistance with the same


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!