Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

0 Replies

Avatar

Correct answer by
Level 7

HI Naushin,

Try this:

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

Hope that helps!