Adding value in a NULL \ empty cell

[sahartz]

Hi,

I have a Null\empty cell that I want to replace with "Original.Due.Date" (only the first Null line).

Can someone let me know how I can edit only this cell (and not the other Null cells I have down the list)?

Thanks,

Sahar

[Luke_C]

Hi @sahartz 

EDIT: Missed the requirement for only the first null cell. @messi007 's solution probably accounts for that way better.

A formula tool and if statement should do the trick. In the formula tool you select the existing corrective action column. The if statement will check if the value for each row is empty (IsEmpty will check for both nulls and empty values), and replace it if that condition is true, otherwise it remains the same.

if isempty([Corrective Actions5])
then [Original.Due.Date]
else [Corrective Actions5]
endif

[messi007 · Accepted solution]

@sahartz,

Please see below

Attached the workflow,

Hope this helps

Regards

[sahartz]

Thanks!!!! Your solution is great if I had only 1 line with Null but I have additional Nulls so I cannot use this solution