Calculation: If Date Field Is Empty....

oakmn

Need help on my survey123 form.

I have a date field "service_date_completed" and a status field "service_status".

I am looking to create a calculation for the "service_status" field where, if there is a date selected for "service_date_completed", then populate with 'Completed'.  If there is no date selected, populate with 'Open'

 

 

KayleeRivera

I would start with a calculation based on field length -- something like if(string-length(${service_date_completed})>0,"Completed","Open").