Hi all,
I've created a system in Smartsheet to capture grant applications and allocate them to individual colleagues to score against a matrix. Each colleague receives an update request with the applications allocated to them.
The problem I'm running into wrt to the above is the batch update request, and the lack of "save" option when updating. Each colleague is receiving upwards of 20 update requests, and with no way to save these the only option is to set aside a huge chunk of time to do all of them at once, which is painful at best and not feasible at worst.
I've considered assigning the requests to sets via some sort of trigger column, and sending out one set a day, but if a colleague misses one or can't do a given set that day, we're back to the update requests lumping themselves together and being too many updates for one sitting, without a save function.
I've also seen the solutions around placeholders, but that solution goes out the window when I send more than 6 requests.
Does anybody have any suggestions?
