Update Date when Health Changes

@emipathy
@emipathy ✭✭✭

Hi All,

I've been tasked with finding a way to automate a column in a health-tracker for our PMO. Here is the ask:

"When [Health]@row changes to Any Value (red/yellow/green/grey), update the [Date of Change]@row with the date the change occured"

Simply, we need a way to automatically track what day the change in health happens. Not many people are in the sheet, as it has multiple feeds, and the 'Date of Change' column often gets neglected.

I'm unfamiliar with returning dates in Smartsheet.

Does anyone have any tips for how to start a formula like this? Or anything similar?

Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!