Formula for checkbox if meets criteria

Hi,

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: https://app.smartsheet.com/b/publish?EQBCT=bb177bd5a51d4634ba15073fc5899d33

Sheet B: https://app.smartsheet.com/b/publish?EQBCT=50702c2c7125446aafd4271eddff6a9f


Does anyone have a solution for this?

Thank you in advance,

Christina

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!