Best answer

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

  • 12 July 2023
  • 3 replies
  • 38 views

Userlevel 1
Badge

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?

icon

Best answer by Brian Moran 12 July 2023, 22:19

View original

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

3 replies

Userlevel 7
Badge +14

Hi @Brian Moran 

Good question.

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

More screenshots would be helpful to provide context.

Userlevel 1
Badge

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

Userlevel 7
Badge +6

Hi @Brian Moran,

That’s great news! We’re glad to know you were able to get it sorted!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 😊