Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Nov 04, 2019 03:53 PM
Goal: Calculate Character count limits for ppc ad sheet.
Character Count field is the number of words in the copy for that ad
Character Limit is the number of words allowed in the ad
IF({Character Count} < {Character Limit}, “ :white_check_mark: PASS”) IF({Character Count} = {Character Limit}, “ :white_check_mark: PASS”) IF({Character Count} > {Character Limit}, “ :x: FAIL”)
Please help! Thanks in advance
Nov 04, 2019 06:57 PM
IF()
statements have an implicit “else” portion as a final clause. You can also check for “less than or equal to.” So your formula should be
IF(
{Character Count} <= {Character Limit},
"✅PASS",
"❌FAIL"
)
Nov 05, 2019 05:53 AM
Thank you so much! Really appreciate your help with this…