Expand my Community achievements bar.

SOLVED

Calculated Field Update help

Avatar

Level 4

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?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 7

HI Naushin,

Try this:

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

Hope that helps!

View solution in original post

2 Replies

Avatar

Correct answer by
Level 7

HI Naushin,

Try this:

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

Hope that helps!