Trouble with nesting formula, could use some advice
Hello,
I am attempting to use nested formula's to create a status update.
I started with, =IF(NO(ISBLANK([Date Submitted to Engineering]),"Sent to Engineering")) and it worked fine. The problem is I need to add multiple status options, with automation like this. So I added the second status and it will not work. Here is the new formula with the second status, I am not sure what I have done wrong.
Can anyone help?
=IF(NO(ISBLANK([Date Submitted to Engineering]),"Sent to Engineering")),IF(NOT(ISBLANK([Site Survey Scheduled]1), "Site Survey Scheduled")
Is there an obvious mistake here? I need to add about 10 status options to this formula, I think it is something to do with syntax, but maybe it's a wrong formula option in the beginning.
Anyway, If someone can see the issue, I would greatly appreciate the help.
Thank you,
Comments
-
Hi,
At a quick glance, I can see that you're missing a T in the first NOT.
=IF(NOT(ISBLANK([Date Submitted to Engineering]),"Sent to Engineering")),IF(NOT(ISBLANK([Site Survey Scheduled]1), "Site Survey Scheduled")
Did it work?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you for looking at this.
It appears I made that error in translation for the discussion. I am still getting the #unparseable response, =IF(NOT(ISBLANK([Date Submitted to Engineering]1)),"Sent to engineering")), IF(NOT(ISBLANK([Site Survey Scheduled]1)), "site Survey Scheduled")))
I welcome any other suggestions.
Thank you, Laura
-
Happy to help!
You have closing parenthesis after the first IF and that's not needed.
Syntax. IF(logical_expression, value_if_true, [value_if_false])
More info: https://help.smartsheet.com/function/if
Try something like this.
=IF(NOT(ISBLANK([Date Submitted to Engineering]@row)); "Sent to engineering"; IF(NOT(ISBLANK([Site Survey Scheduled]@row)); "Site Survey Scheduled"))
The same version but with the below changes for your and others convenience.
=IF(NOT(ISBLANK([Date Submitted to Engineering]@row)), "Sent to engineering", IF(NOT(ISBLANK([Site Survey Scheduled]@row)), "Site Survey Scheduled"))
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!