Nested if returning cell value

Jacque · 01/15/19

Hi All,

I'm trying to create a nested if that will bring back the value of another cell if true. I can make it work in Excel but when I try to recreate in Smartsheet, I'm close but not quite there:

Excel Formula:

=IF(I8="Invoice Reconciled",0,IF(I8="Work Not Started",0,IF(I8="Completed/Not Invoiced",H8)))

Smartsheet Formula:

=IF(Status7 = "Invoice Reconciled", "0.00", IF(Status7 = "Work Not Started", "0.00", IF(Status7 = "Completed/Not Invoiced", "Invoice Amount7")))

Screen shot attached! Help please!!

Thanks!

Jacque

Nested If Invoice Scenario.jpg

Brian W · 01/15/19

It looks like those quotes are throwing off your formula. Try this:

=IF(Status7 = "Invoice Reconciled", 0, IF(Status7 = "Work Not Started", 0, IF(Status7 = "Completed/Not Invoiced", [Invoice Amount]7))

You could also combine the first two instances with OR:

=IF(OR(Status7 = "Invoice Reconciled", Status7 = "Work Not Started"), 0, IF(Status7 = "Completed/Not Invoiced", [Invoice Amount]7))

Paul Newcome · 01/16/19

Brian is correct. It was just an improper column reference. Any column name that contains a space, number, or special character needs to be wrapped in [Square Brackets].

Nested if returning cell value

Comments

Help Article Resources

Categories