Question - I want to set the value of a column but only if a specific value in another column is selected.
The pic below can show what I mean.
I don’t want to attempt a
workflow data change because those have messed up before.
I thought if I put a valid if expression in the column it would apply the initial value to only items meeting that criteria but not the case.
Yes, Need Transport - set transport status to “awaiting transport” Yes, driving self - no status update
Can you do this without the workflow?