Send report to manager of those who haven't completed form submission request.
Hi,
I have created a form that is sent daily to all employee's at 4pm where they have to provide a review of the day.
At 6pm, a report is then sent to the respective managers showing what their direct reports have submitted.
However, I somehow need the report that is sent to the manager to show those who haven't submitted their forms.
Best Answer
-
=COUNTIFS({Form Sheet DAte Column}, @cell = TODAY(), {Form Sheet Name Column}, @cell = [Name COlumn]@row)
Answers
-
You would need to have a comprehensive list of all employees. From there you would use a COUNTIFS on each row to count how many times that employee's name shows up on the form submission sheet for TODAY().
If that COUNTIFS(.....) = 0, then that employee has not filled it out for today.
-
Thanks Paul. What would the complete formula be??
-
You would use a COUNTIFS to look for the name and the date of today.
=COUNTIFS({1st Criteria Range}, 1st Criteria, {2nd Criteria Range}, 2nd criteria)
-
Thanks but I really can't work out how to formulate this.
Column 1 is name - "Cindy Balfour"
Column 2 is date - "26/01/2023"
-
=COUNTIFS({Form Sheet DAte Column}, @cell = TODAY(), {Form Sheet Name Column}, @cell = [Name COlumn]@row)
-
Thanks, worked perfectly!!
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives