Need help with Character Count Formula

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

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

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