Formula for checkbox if meets criteria


I've kind of asked this question before, but the formula that was suggested doesn't work on multiple dates.

I have sheet A and Sheet B

Sheet A has columns of ID# and Date

Sheet B has columns of ID#, Date 1, Date 2, Date 3 etc...

The formula I have in sheet B didn't work when there is a different date column in the same sheet.

=IFERROR(IF(DATE(2021, 8, 26) = INDEX({sheet A date complete}, MATCH([ID #]@row, {Demo Sheet A ID}, 0)), 1), "")

Sheet A:

Sheet B:

Does anyone have a solution for this?

Thank you in advance,




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!