I was trying to use the following condition to fire an action in the automation (to send an email):
AND([_THISROW_BEFORE].[Percentage Completed] < 1,
[_THISROW_AFTER].[Percentage Completed] = 1)
But it doesn’t work. [Percent Completed] is a virtual column. Does it have anything to do with the problem I’m facing by any chance?
Another info here, the following condition, which is quite similar to the first one, works just fine in another bot:
AND([_THISROW_BEFORE].[Status] = “Open”,
[_THISROW_AFTER].[Status] = “In Progress”)
[Status] is not a virtual column.
Feel free to speak if you need further info about the problem I’m facing. Thanks.