Nested if returning cell value

Jacque
Jacque
edited 12/09/19 in Formulas and Functions

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

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!