Date stamp does not trigger when Health changes in cell for a referenced value from another sheet

Options

Hi all,

I've followed the article Set the current date with the Record a Date action | Smartsheet Learning Center and was unable to get a date stamp to populate in a cell when a project's Health changes. Essentially we have a Project Rollup sheet which lists all our projects provisioned via SCC and the health values are referenced.

I understand that at times the automation might not recognize the cell value being changed as it is only the color; in another scenario we noticed if the reference changes that is when it registers as a change.

Here's my automation below using colors as the trigger for change - I've also used "Any Value" with no success.



Answers