Best answer

Failed to create a text transform in Formatter by Zapier: The app returned "Unknown Function:'.IF

Forum|Forum|2 years ago
July 12, 2023
3 replies
136 views

Brian Moran
Beginner

Hi, I am trying to use a spreadsheet to assign a value based on another value, see below

({{197433583__company_size_on_linkedin}} < 11,"1-10",
IF({{197433583__company_size_on_linkedin}} < 51,"11-50",
IF({{197433583__company_size_on_linkedin}} < 201,"51-200",
IF({{197433583__company_size_on_linkedin}} < 501,"201-500",
IF({{197433583__company_size_on_linkedin}} < 1001,"501-1000",
IF({{197433583__company_size_on_linkedin}} < 5001,"1001-5000",
IF({{197433583__company_size_on_linkedin}} < 10001,"5001-10000",
IF({{197433583__company_size_on_linkedin}} > 10000,"10000+"))))))))

Receiving the below error:

Can anyone help?

Best answer by Brian Moran

Managed to get it working. Here is the final formula:

IF({{197433583__company_size_on_linkedin}} < 1, "Unavailable",IF({{197433583__company_size_on_linkedin}} < 11, "1-10",IF({{197433583__company_size_on_linkedin}} < 51, "11-50",IF({{197433583__company_size_on_linkedin}} < 201, "51-200",IF({{197433583__company_size_on_linkedin}} < 501, "201-500",IF({{197433583__company_size_on_linkedin}} < 1001, "501-1000",IF({{197433583__company_size_on_linkedin}} < 5001, "1001-5000",IF({{197433583__company_size_on_linkedin}} < 10001, "5001-10000",IF({{197433583__company_size_on_linkedin}} > 10000, "10000+", " ")))))))))

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

+14

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|Forum|2 years ago
July 12, 2023

Hi @Brian Moran

Good question.

In what app/event are you trying to use this formula?

More screenshots would be helpful to provide context.

⚡ Troy Tessalone - AutomationAce.com | Top Zapier Solution Partner | #1 Zapier Community Contributor

Like

Brian Moran
Author
Beginner
Answer
Forum|Forum|2 years ago
July 12, 2023

Managed to get it working. Here is the final formula:

IF({{197433583__company_size_on_linkedin}} < 1, "Unavailable",IF({{197433583__company_size_on_linkedin}} < 11, "1-10",IF({{197433583__company_size_on_linkedin}} < 51, "11-50",IF({{197433583__company_size_on_linkedin}} < 201, "51-200",IF({{197433583__company_size_on_linkedin}} < 501, "201-500",IF({{197433583__company_size_on_linkedin}} < 1001, "501-1000",IF({{197433583__company_size_on_linkedin}} < 5001, "1001-5000",IF({{197433583__company_size_on_linkedin}} < 10001, "5001-10000",IF({{197433583__company_size_on_linkedin}} > 10000, "10000+", " ")))))))))