Automations on Absolute Values

nlcurtis

I am unable to make an automation work based on an absolute value field. Is this a limitation in automations or am I doing something wrong?

jmyzk_cloudsmart_jp

Hi @nlcurtis

I could make an automation work based on an absolute value field.😀

Please check the published demo sheet below. The automation checks the ABS value, and if it is greater than 1, checks the Checkbox; if it is equal or less than 1, unchecks it.

https://app.smartsheet.com/sheets/Fm84C2x5W6G2w6WG5gFr2vW5rc8V3F5vM3P6G9p1?view=grid

jmyzk_cloudsmart_jp

Hi @nlcurtis

I could make an automation work based on an absolute value field.😀

Please check the published demo sheet below. The automation checks the ABS value, and if it is greater than 1, checks the Checkbox; if it is equal or less than 1, unchecks it.

https://app.smartsheet.com/sheets/Fm84C2x5W6G2w6WG5gFr2vW5rc8V3F5vM3P6G9p1?view=grid

nlcurtis

Thank you for confirming you're able to complete an automation on this function. I left it for a few hours and came back to it and I'm able to get it working now.

jmyzk_cloudsmart_jp

Happy to help!😁