Check box IF date in a list
Options
Julie Barbeau
✭✭✭✭
Hi,
I'm trying to figure out how to create a column that has a checkbox when a date in one cell is one of a list of dates in another sheet but it doesn't seem to work. See below, 211115 should be checked as this date is in my list. Here is the formula I use : =IF(CONTAINS([End date]@row; {Férié Plage 1}); 1; 0)
Best Answer

are both your columns formatted as Date columns? They would need to be Text/Number columns for the formula to check the boxes.
Answers

are both your columns formatted as Date columns? They would need to be Text/Number columns for the formula to check the boxes.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!