How to change values in cell based on other cell value

[rshetty]

Hi All,

I am new so not sure how this works but just trying my luck.

Need help with the below.

Product ID	Sub ID	Status	StatusA
123			Pass
	123	fail
	123	Pass
	123	TBD
	123	medium

I want to update the 'StatusA'  column based on the 'Status"  column value, Status A is already updated but needs to be updated based on column 'Status'. In this case I want the column ' StatusA' updated as " fail ".  If there is no " fail" then Status A should pick "TBD". So the ranking is 1. Fail 2. TBD 3. Pass 4. Medium. I have multiple Product Ids where 'StatusA' should reflect SubID Status based on the ranking.

Thank you

Rishi 

[danilang · Accepted solution]

Hi @rshetty 

Here's one way to do it

The workflow concatenates the Status values for the Sub Id rows and then calculates the new status with an if-then-else based on your ranking order.  This new status is joined with ProductID rows and unioned with SubID rows and sorted to give you

Dan

[rshetty]

Thanks, Dan for your swift response. My issue is resolved. God bless.