Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Mar 15, 2021 01:04 PM
Mar 29, 2021 04:29 PM
Hello and welcome @Anand_Ashar!
Automations do not currently allow you to use mathematical operators when setting fields:
To get around this you could write a custom script to use as your Automation action that would allow you to update a field on a record using whatever equations you’d like.
Let me know if I can help provide any more information and if this helped answer your question please mark it as the solution :white_check_mark: .
Mar 29, 2021 08:01 PM
Thank you so much. Appreciate the help!