Sep 03, 2021 04:20 PM
I’m trying to create a formula where if two records are true it prints an answer. Here’s my formula: IF(AND({Role}= “Free”),{# Plans} => 5),“Cannot Add Plans”). I want it to show Cannot Add Plans if the Role = Free and the # of Plans => 5. It’s not working. Any help would be appreciated.
Sep 03, 2021 05:07 PM
You need to remove the “)” after “Free” and flip the order of the operators after {# Plans} to “>=”. If the AND is still not happy, add more parens to completely separate the two boolean expressions. Good luck.
Sep 03, 2021 05:20 PM
YES!!! Thank you so much!