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.
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |