Set up notification for a complete workspace

Yvonne B.

Hi,

I'm doing project management amongst multiple projects (1 project = 1 sheet) that are all in one workspace.

Is there a possibility to set up a notification for the complete workspace?

It's quite anoying to set up a notification to each single sheet.

As I read in another discussion it's not possible to use notification in a template, so I even can't have it automatically for new projects...

 

Thanks :-)

 

Best regards

Yvonne

Richard Rymill SBP

Hi Yvonne

maybe you can do this a different way round then? 

Try creating a Report that only looks in your chosen Workspace. Assuming that all your sheets are of the same structure (column names identical) then create a Report that has the right columns inc. Sheet ID and filters only what would be a trigger for being notified and "they" will appear as a list of your "to Do's". From there you can action the work and remove the action. 

That should be a whole lot easier than what you describe? 

Good Luck

RichardR

Mattisphere

Richard, you're suggesting being able to see all of the information on one report and checking it on a regular basis and not setting up reminders at all, correct? Without reminders or notifications as a feature on reports, I'm not sure that solves her problem, but it might make it an easier task.

Yvonne B.

Hi,

thanks for your replies.

I tried to configure a report and it looks okay, but does not fully fit to my requirements.

The report shows who changed something and which value, but it can't display in which column the user changed this.

The problem is that the other users are also allowed to modify multiple columns, so for example I can see that user A changed a value to date XY and time XY, but I don't know which date this is, could be start or end date...

Additionally I can't see the former value (this would not be super important, but nice to have).

Any idea how I can see which columns were changed?

 

Thanks :-)

Richard Rymill SBP

Hi Yvonne and Matt, my default is always to keep things as simple as possible and without studying your exact setup two quick answers are... Use the Highlight Opdates button in either the Master Report or individual sheet to spot the changes, then use the Right Click Cell History to tell you who did what and when. 

 

If you knew all that already, my apologies,

You could add on your template sheet. two system columns for the Date Row Changed and by who last changed this Row. But it duplicates the above.

Let us know how you get on and happy to help you refine this if need be, to get exactly what you seek? 

 

RichardR

 

Yvonne B.

Hi Richard,

thanks, with this modification it's a good workaround for me :-).

I didn't check how the highlight changes is working, I assumed that it's the same as in an Office Word document etc. that you need to flag it first and then it highlights etc.

But in the way it's working here in Smartsheet, it's perfect for me and if I need more details, I can use the right click with the change details.

 

Thanks :-)

 

Best regards

Yvonne

Richard Rymill SBP

Excellent news Yvonne, glad to have helped. 

 

RichardR