Need urgent assistance on replacing cell value based on condition

RaviPM10

Hi Team ,

can you please guide me in achieving below results

I'm trying achieve result base on specific cell condition

Conditions

if account / group name is ‘Sun’ and locked status is F then locked status for all below account Name should be Final
if account / group name is ‘Sun’ and locked status is P then locked status for all below account Name should be Prelim

I' tried to use this formula

IF [Account / Group Name] = 'Sun' AND [LockedStatus] = 'F' THEN 'Final'

ELSEIF [Account / Group Name] != 'Sun' THEN 'Final'

ELSE 'Prelim' Endif

when Locked Status is P for Sun in that scenario its working fine however when locked Status of F in that case its not giving desired output

Test.yxmd

Topic of Interest

Help

Accepted answers

binu_acs

@RaviPM10 let me know if the attached workflow works for you

Test (13).yxmd

All comments

binu_acs

@RaviPM10 Which condition it is not working? The account/group name of locked status F is sea which is satisfying the second condition

RaviPM10

@binu_acs 2nd condition is not working

"if account / group name is ‘Sun’ and locked status is P then locked status for all below account Name should be Prelim'

binu_acs

@RaviPM10 When you say All the Account Name, what does that mean, Can you provide your expected result, which will help to understand your use case better

RaviPM10

Please refer to attached file

Book2.xlsx

binu_acs

@RaviPM10 let me know if the attached workflow works for you

Test (13).yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703