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:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/a1d07f54-5cd7-4e89-906e-516ddf2d96ca.png)
Can anyone help?
Best answer by Brian Moran
View original