Solved

Calculated Field Update help

Hello... I have a question on a calculated field we have that pulls data from two different fields into one with the following If statement:

IF(ISBLANK(CSBrand),BrandDepartmentNonAutomation,CSBrand)

We've added a third variable, which is if both CSBrand and BrandDepartmentNonAutomation fields are blank, then this field needs to be "PER"

How do I modify this If statement to reflect the added variable?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by SarahNa

HI Naushin,

Try this:

IF(ISBLANK(CSBrand),IF(ISBLANK(BrandDepartmentNonAutomation),PER,BrandDepartmentNonAutomation),CSBrand)

Hope that helps!

SarahNaAccepted solution

HI Naushin,

Try this:

IF(ISBLANK(CSBrand),IF(ISBLANK(BrandDepartmentNonAutomation),PER,BrandDepartmentNonAutomation),CSBrand)

Hope that helps!

Thank you Sarah!

Sign up