It would be really useful if users could create automation in the following manner:
IF rating changes AND rating value is lower than (i.e.) 5 THEN …
I agree. In the meantime I found a workaround, maybe it’ll help someone so posting it here:
Create a formula column which shows the value of the rating column (it will make it a number rather than rating). Then you can perform automations with the new column.
@danielg I attempted this but I still cannot perform automations on the new formula column. Let’s say the “satisfaction” score we got back from a survey was 4 stars. The formula I made in the “Rating” column takes that and puts a number 4 in that column. But when I try to automate with that number, it recognizes it as a formula, not a number since it’s not reading from a number column. Any advice?
