Automatically check if

ultimatum
ultimatum ✭✭
edited 09/08/23 in Formulas and Functions

If any formula, after filling form check-in or out will be checked automatically if a person is checking in this day?

I need to know if some ppl already check in or out from the another list (sheet).



Answers

  • MichaelTCA
    MichaelTCA ✭✭✭✭✭✭

    Hello @ultimatum

    You can use a lookup function like Index/Match. RANGE1 would be the column that would specify that the person is already checked in or out from the other sheet.

    =INDEX(RANGE1,MATCH(Lookup Value, RANGE2, 0)

    This function will check the box on this sheet if it's already checked on the other.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!