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,

Find more posts tagged with

Formulas

Comments

Andrée Starå

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

1_UTOPIAlk

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

Andrée Starå

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

Sign in to join the conversation!

Quick Links

Trending discussions

Calculating Quarters with a Start and a Finish date
I searched the community and did not see a formula that calculated Quarter based on a Start and a Finish date while also accounting for cases where the year for the Start and Finish date differ. The formula below handles that. A few notes … It assumes that Finish is always >= Start. The entire formula is wrapped with…
Circular Reference with formula
i am not good with writing formulas within a sheet. I asked the AI tool in the sheet to help me write a formula and I am getting a Circular reference back. I'm trying to have it write the following formula for me. If the column "Tracking #" is not blank, change Column "Deployment Phase" to "Shipped" I have tried adding in…
How to delay the execution of a workflow whose trigger occurred much earlier?
I have a workflow that detects a row(date) that is changing its Fiscal Week Finish Date and send this row to other Sheet. Long story short: I collect delayed tasks in separate file & I tag reasons for delay for these tasks. It happens that plan are analyzed 2-3 hours and dates are being changed several times. I would like…