IF function

Laura_Murphy

Hello I am trying to write a formula that will automatically fill the 'status' column as Confirmed if the 'Booked' Column has a date input but not if it is blank?

I would be grateful for any help you can provide

Jeff Hoelzel

=IF([Booked]@ROW<>"","Confirmed","")

Make sure that Date is checked in the Booked column properties.

Laura_Murphy

Thanks - unfortunately this still isn't working it might be as I have a list of answers for status to I might not be able to add in this formula as well?

Jeff Hoelzel

If you are going to have multiple statuses, we'll need to build a nested IF formula. What are your statuses and what are the conditions for each?

David Joyeuse

Hi @Laura_Murphy

Use this formula:

=IF(ISDATE([Booked]@row),"Confirmed","")

But as Jeff said, it would be better to check every possible case in the IF statment so the formula is complete. But if all you want is to have status confirmed, use the formula above as it'll work only when there's a date in [Booked]@row.

Hope it helped!

Laura_Murphy

This has worked David thanks so much to both of you!