If Statements

Hello All,

I am attempting to create an If statement that raises a flag if two rows have the same location and the same date.

This submission sheet will be used when people visit a location and we do not want any double bookings. So I was planning on having a formula raise a flag and then have a report that looks for the flag to put on our dashboard.

The sheet is very simple, just a list of location names in one column and the date the person is planning on visiting that location, there are several hundred locations to choose from.

Appreciate the help or advice if you think I am going about it the wrong way.



Best Answer


  • @David Joyeuse Thank you. I had googled it and got a similar formula that didnt work, thank you this worked perfect. Also thanks for the quick response.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!