Automatically check if
ultimatum
✭✭
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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!