How to use IF(ISBLANK and another IF formula?



I am using this formula =IF(AND(NOT(ISBLANK([Latest Update]@row)), Level@row = 2), "Update", "") and I would like to add =IF(Level@row = 1, "Project Update") if it is Not Project Update it it needs to be blank.

When I put them together I keep getting an error. =IF(AND(NOT(ISBLANK([Latest Update]@row)), Level@row = 2), "Update", ""), IF(AND(NOT(ISBLANK([Latest Update]@row)), Level@row = 1), "Project Update", "")

Any assistance is appreciated.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!