Question

Hi,

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.

Thanks!

Jana Brits · Accepted Answer

Hi Tina

Try this formula:

=IF(AND(NOT(ISBLANK([Latest update]@row)), Level@row = 2), "Update", IF(AND(NOT(ISBLANK([Latest update]@row)), Level@row = 1), "Project Update", ""))

Kind regards,

Jana

Paul Newcome · Accepted Answer

It is actually an issue with the nested IF's. Give this a try...

=IF(AND(NOT(ISBLANK([Latest Update]@row)), Level@row = 2), "Update", IF(AND(NOT(ISBLANK([Latest Update]@row)), Level@row = 1), "Project Update", ""))