▶️ Status formula based on Start/Finish Date...
InfoStart DateEnd Date% CompleteCreatedCreated ByModifiedModified By
 Collaboration powered by Smartsheet   |   Report Abuse
1
TODAY'S DATE
07/15/2406/12/24 8:00 AMdan@schoolofsheets.com07/15/24 6:48 AMadmin@schoolofsheets.com
2
-Formula Output
06/12/24 8:00 AMdan@schoolofsheets.com06/12/24 8:00 AMdan@schoolofsheets.com
3
Complete
06/12/24100%06/12/24 8:00 AMdan@schoolofsheets.com06/12/24 8:00 AMdan@schoolofsheets.com
4
Future Task
07/16/240%06/12/24 8:00 AMdan@schoolofsheets.com07/15/24 6:48 AMadmin@schoolofsheets.com
5
Late
07/12/2407/14/240%06/12/24 8:00 AMdan@schoolofsheets.com07/15/24 6:48 AMadmin@schoolofsheets.com
6
Complete
07/12/2407/14/24100%06/12/24 9:26 AMdan@schoolofsheets.com07/15/24 6:48 AMadmin@schoolofsheets.com
7
On Schedule
07/14/2407/16/240%06/12/24 8:00 AMdan@schoolofsheets.com07/15/24 6:48 AMadmin@schoolofsheets.com
8
Formula Text
06/12/24 8:00 AMdan@schoolofsheets.com06/12/24 8:00 AMdan@schoolofsheets.com
9
*=IF([% Complete]@row = 1, "Complete", IF([Start Date]@row > TODAY(), "Future Task", IF([End Date]@row < TODAY(), "Late", "On Schedule")))
06/12/24 8:00 AMdan@schoolofsheets.com06/12/24 8:00 AMdan@schoolofsheets.com