Workflow condition doesn't work

[Olivia_Bryanne1]

Hi there,

I’m trying to make an action-triggered workflow to notify users. The sequence is that one user is working on a specific entry and when they’re ready, there is a share button (action) that sets the value of a hidden timestamp column to now(). There is then a workflow that says whenever there is an update to entries on this table it should fire an email to the right people, but only when ISNOTBLANK([hidden timestamp column]). But the email is fired on every update, even without the condition being satisfied.

Any suggestions? thanks

Olivia

[Aleksi · Accepted solution]

Use AND(ISNOTBLANK([TimestampColumn]),[_THISROW_BEFORE].[TimestampColumn]<>[_THISROW_AFTER].[TimestampColumn]). This will fire your Workflow only when the action button is pressed.

[Olivia_Bryanne1]

Aleksi:

AND(ISNOTBLANK([TimestampColumn]),[_THISROW_BEFORE].[TimestampColumn]<>[_THISROW_AFTER].[TimestampColumn])

excellent, thanks a lot!

[Aleksi]

You’re welcome