Record a date automation not working?

Robin Herrick · 05/08/22

I have a similar but different issue. I have 3 status descriptors in a Status column, and 3 columns to capture what dates those statuses were entered using 3 separate automations. The automations also trigger a change notification & email. I get the email, so the automations are triggering, but the date recording doesn't work.

I see what is happening now. It is recording the date based on the previous status.

When Status changes to "New", Record a date in "Creation Date". But the date actually records in a different column depending on the prior status.

Robin Herrick · 05/08/22

I've tried separating out the notification and column update steps but still get the same result.

Robin Herrick · 05/22/22

There's not much activity in these forums is there?

Robin Herrick · 05/22/22

I figured out what is going on. In case anyone is interested. It's a synchronisation issue. The automation runs but it doesn't update the displayed sheet until you refresh it.

Genevieve P. · 05/23/22

https://community.smartsheet.com/discussion/comment/328812#Comment_328812

Hi @Robin Herrick

From your additional comments it sounds like these automations are now running as expected. Another detail to note about actions that change a sheet (e.g. Record a Date or Move Row) is that they can't be triggered by cross-sheet formulas or cell-links. Here's an article with more information: Trigger Blocks: Define When Your Workflow is Executed

If your workflows aren't executing as you'd like in the future, it would be helpful to see a screen capture of the current workflow configuration and your sheet set-up, but please block out sensitive data.

Cheers,

Genevieve

Record a date automation not working?

Answers

Categories