Check box IF date in a list



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, 21-11-15 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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!