Help

Need help with Character Count Formula

Topic Labels: Formulas
1396 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Joe_Spur
4 - Data Explorer
4 - Data Explorer

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"
    )
Joe_Spur
4 - Data Explorer
4 - Data Explorer

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