Formula to change line item to 'at risk' when due date is passed
Goal: When a finish date is passed on a line item, I want the status column to change to 'at risk'.
Best Answers

Hey @Daniel Marcel
=IF(TODAY()>Finish@row, "at risk")
May I suggest you add another condition to 'turn off' counter. As is, when Today's date passes Finish, the status will turn to at risk, regardless if the task was completed already.
cheers,

Hey Daniel
You can either drag this formula down the column or, more preferably, make this formula a column formula by right clicking in the cell with the formula and, at the bottom of the list of actions, is 'Convert to Column Formula'. Note that to edit a formula after converting to a column formula you must rightclick a cell within the column and choose either 'edit column formula' or 'convert to cell formula'. You will not be able to edit the cell directly.
Answers

Hey @Daniel Marcel
=IF(TODAY()>Finish@row, "at risk")
May I suggest you add another condition to 'turn off' counter. As is, when Today's date passes Finish, the status will turn to at risk, regardless if the task was completed already.
cheers,

That's awesome, thank you so much @KDM
Am I able to apply this to all line items somehow rather than individual line items?

Hey Daniel
You can either drag this formula down the column or, more preferably, make this formula a column formula by right clicking in the cell with the formula and, at the bottom of the list of actions, is 'Convert to Column Formula'. Note that to edit a formula after converting to a column formula you must rightclick a cell within the column and choose either 'edit column formula' or 'convert to cell formula'. You will not be able to edit the cell directly.

Awesome thank you so much @KDM
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.9K Get Help
 376 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 284 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!