#UNPARSABLE / #INCORRECT ARGUMENT

Tom Stock

Having trouble trying to make this formula work. Perhaps it needs re writing using different syntax.

I understand that perhaps i am using too many arguments for the IF command.

I am looking to achieve the below.

• If Column1 is not blank and Column2 is not blank, return "Answer 1".

• If Column1 is not blank and Column2 is blank, return "Answer 2".

• If Column1 is blank and Column2 is not blank, return "Answer 3".

• If Column1 is blank and Column2 is blank, return "Answer 4".

=IF(AND(NOT(ISBLANK([CHASISS NO.]@row)), NOT(ISBLANK([STOCK CUSTOMER]@row))), "In Stock - Allocated", IF(AND(NOT(ISBLANK([CHASISS NO.]@row)), ISBLANK([STOCK CUSTOMER]@row)), "In Stock - Unallocated", IF(AND(ISBLANK([CHASISS NO.]@row, NOT(ISBLANK([STOCK CUSTOMER]@row))), "On Order - Allocated", IF(AND(ISBLANK([CHASISS NO.]@row), ISBLANK([STOCK CUSTOMER]@row)), "On Order - Unallocated", "No Match")))))

Adam Murphy

Hi Tom, Try this: =IF(AND(NOT(ISBLANK([CHASISS NO.]@row)), NOT(ISBLANK([STOCK CUSTOMER]@row))), "In Stock - Allocated", IF(AND(NOT(ISBLANK([CHASISS NO.]@row)), ISBLANK([STOCK CUSTOMER]@row)), "In Stock - Unallocated", IF(AND(ISBLANK([CHASISS NO.]@row), NOT(ISBLANK([STOCK CUSTOMER]@row))), "On Order - Allocated", IF(AND(ISBLANK([CHASISS NO.]@row), ISBLANK([STOCK CUSTOMER]@row)), "On Order - Unallocated", "No Match"))))

mcullen

Hi @Tom Stock! Have you tried using the AI Tool "Generate Formulas"? It's my go to when I'm stuck and has been a life saver. You should be able to copy and paste the description of what you are trying to achieve in the formula description.

Adam Murphy

Hi Tom, Try this: =IF(AND(NOT(ISBLANK([CHASISS NO.]@row)), NOT(ISBLANK([STOCK CUSTOMER]@row))), "In Stock - Allocated", IF(AND(NOT(ISBLANK([CHASISS NO.]@row)), ISBLANK([STOCK CUSTOMER]@row)), "In Stock - Unallocated", IF(AND(ISBLANK([CHASISS NO.]@row), NOT(ISBLANK([STOCK CUSTOMER]@row))), "On Order - Allocated", IF(AND(ISBLANK([CHASISS NO.]@row), ISBLANK([STOCK CUSTOMER]@row)), "On Order - Unallocated", "No Match"))))

Tom Stock

Hi Michelle,

Thanks for the reply. I tried AI a couple of times but still didn't help.

Tom Stock

https://community.smartsheet.com/discussion/comment/452700#Comment_452700

Hi Adam,

Thanks for this. This sorted my issue!

Assuming i was just missing some information?

Adam Murphy

You just had a misplaced ) in yours. Glad it worked!