Hello, Community!
I have a multi-user Smartsheet where junior managers must enter a date in a designated cell (date approved) once they submit their required monthly report.
Once all of these reports for a given store have been received, only then can that store's Senior Manager begin developing his/her report. Currently, each Senior Manager must access the sheet and look for their store to see if all of their junior managers for a given store have submitted their reports (as in entered a date in the 'date approved' cell) so they can begin writing the Senior Manager reports.
Is there a function (e.g. notification or report) where the senior managers will be notified once all of the junior manager reports for a given store have dates in their 'date approved' cell?
I know I can send a specific notification to a specific user for a specific cell, but can I group cells to say when cells D14-D21 have dates in them a notification will be sent to the appropriate senior manager (e.g. all the reports for the Southgate stores are in). Will this notification include information about which store is ready for its senior report?
And as bonus problem....
Can this notification include a link to a report if it's in another document repository outside of Smartsheet (e.g. TouchPoint?)
Thanks, all! This is time-sensitive request so I truly appreciate any quick response.
THANKS!!!!!