Calendar Tasks to outlook for assigned tasks only
I published the iCal link to my outlook calendar, the problem is that every task on the Smartsheet shows on my calendar. We have around 15 people to whom tasks have been assigned. It would be great if we could link just their tasks to their calendar. Having all the tasks clogs up the calendar and is pretty much useless. I tried filtering first, that did not change anything.
Is there a way to link my tasks to my calendar and each of the other team members to be able to do the same thing?
Comments
-
Unfortunately, Reports don't work (unless I have missed something)
The X-Sheet Reference solution I describe here:
http://ronin-global.com/2018/02/22/smartsheet-secure-your-sheets-with-x-sheet-references/
can be leveraged to pull only selected rows meeting certain criteria, tasks could be one of them.
How many source sheets do you have? 15 users pulling from a single sheet or across sheets and workspaces?
Craig
