IF function
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
Answers

=IF([Booked]@ROW<>"","Confirmed","")
Make sure that Date is checked in the Booked column properties.

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?

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?

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!

This has worked David thanks so much to both of you!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.8K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.6K Ideas & Feature Requests
 56 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!