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
Hi @vssrsairam
Is there any logic or are you just filling the null values from the previous non-null value? If so, look into the multi-row formula tool - there are numerous examples on the community solving this exact fact pattern
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
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
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