What Formula should I use.....?

Lpv_11

Hello Team

I need to change the status to Yes when the END DATE has been entered. Or NO, if the date is still blank. So, if the date was entered, the status will change to YES; if it is not, the status will be NO.

Please see attached.

Thank you again for your help!

markkrebs

if(isblank([End Date]@row),"No","Yes")

markkrebs

if(isblank([End Date]@row),"No","Yes")

Peggy Parchert

Hello @Lpv_11

To add to @markkrebs answer, I would make the column a column formula column.

Right click on the Yes/No column and scroll to the bottom and select Convert to Column Formula

Lpv_11

OH MY GOD! IT Worked!! Thank you so so much! :)

markkrebs

Yes - always use column formulas when possible