#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")))))

Find more posts tagged with

Accepted answers

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

All comments

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

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.