How would I have a Yes/No column change to true once I change a value of a single column in the table? I have created an action that changes the value to true and I have that hidden. Then I have a workflow rule that when there is an UPDATES_ONLY data change the DO THIS action is Change Data and the action is the one that changes it to true. What Condition could I use to make it only do it when there is an update only to a certain column?
You can use [_THISROW_BEFORE].[column] <> [_THISROW_AFTER].[column] as condition for the workflow.
help.appsheet.com - Workflow Workflow help.appsheet.com
And please remember to use ISNOTBLANK([Column]) as well. Otherwise it will trigger the workflow when you add a new record and the condition is not true.
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |