Help

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.

Need help with Character Count Formula

Topic Labels: Formulas
719 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

2 Replies 2

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"
    )

Thank you so much! Really appreciate your help with this…