Formula(s) to highlight missing time submissions
Hello,
I have a front-end form used to collect an employee's name, date, and login time each morning. The same form collects an employee's name, date, logout time and daily work log at the end of that same day, so each employee should have two rows created each day.
Is there a formula that can cross-check the date field with the employee name field to ensure two rows exist for each employee for each day? If so, I may be able to use conditional formatting to highlight rows that don't equal 2.
In the end, it'll save me a lot of time if SS can highlight those employees who don't submit two time submissions each day. I hope that makes sense.
Thank you!
Answers
-
Is there a chance that you could share a snapshot of the Sheet to help give a clearer picture of the problem and what you are trying to accomplish?
Hope this helps!
Heath Hilton
-
Hi @Scott Bales
I hope you're well and safe!
Try something like this.
= IF(Date@row <> "", IF(COUNTIFS(Date:Date, Date@row, Employee:Employee, Employee@row) > 1, 1))
Did that work/help?
I hope that helps!
Have a fantastic week & Happy Holidays!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
That worked, Andree. Thank you very much. I appreciate it!
-
Excellent!
You're more than welcome!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Glad to hear that it was helpful for you too!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!