Populate the same data based on a value

Question

I have a column called Request Type & it has 3 values > "Build" , "Upgrade" & "Update" requests

and in another column called - > "DM Owner" - The Owner being requested & data exists Only for "Build" Request & data not exists for "Upgrade" & "Update" requests .

so need to populate same "build" owner names also for "Upgrade" & "Update" requests in DM Owner column, but only when there is "null" .

please let me know if anyone has idea on this

data.csv

martinding · Answer

Hi @vssrsairam,

Based on this data, it seems that BUILD refers to the initial entry, whereas UPDATE and UPGRADE follow from BUILD.

Therefore, the logic is:

IF IsEmpty([DM Owner]) AND [Request Type] = "BUILD"

THEN Null()          \* If for some reason DM Owner is null/empty when Request Type is null, then it should be left as null and investigated further.*\

ELSEIF IsEmpty([DM Owner]

THEN [Row-1:DM Owner]     \* For cases where DM Owner is null/empty but Request Type is other than BUILD, we take the previous row's value.*\

ELSE [DM Owner]      \* In all other cases, we keep the original value in the DM Owner field*\

ENDIF

Luke_C · Answer

Hi @vssrsairam

There doesn't seem to be any ID relating the rows, but the below formula in a multi row formula tool should do the trick:

IF isnull([DM Owner])

THEN [Row-1:DM Owner]

ELSE [DM Owner]

Endif

vssrsairam · Answer

hello @Luke_C , thanks for reply

Don't have any condition just need to fill the same owner names in place of nulls based on "Build" request value