adding status "review" for null data

[Connor_Sullivan]

My data has three columns: Status, PO Box, and Address. I want the Status to be “REVIEW” if both Address AND PO Box are nulls. 

[RaviP]

Hi @Connor_Sullivan,

In the formula object, set the output column to 'Status'

if IsNull([PO Box]) and IsNull([Address])

then 'REVIEW'

else [Status]

endif

This should do the trick.

[apathetichell]

@RaviP's solution is great if there is no possibility that an errant "review" is currently in [status] - if this is not true - you'll need the second part of the statement (ie the else clause) to point to something like "", null() - or whatever you want the non-Review value to be.