Is it possible to use Group information in Smartsheet Reports?
Hi
Is it possible to access the Group that a resource in the 'Assigned To' column is a member of, in Smartsheet Reports, eg like doing a VLOOKUP on the resource name?
Many thanks.
Nigel
Best Answer
-
You will need to create a lookup sheet that has that information and then do a lookup value on it. No current way to get sharing information programmatically.
Cheers,
Ramzi
www.cedartreeconsulting.com
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
Answers
-
You will need to create a lookup sheet that has that information and then do a lookup value on it. No current way to get sharing information programmatically.
Cheers,
Ramzi
www.cedartreeconsulting.com
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
-
Ok - that seems silly - not only do you need to maintain a list of Groups and Users but you must also maintain another list containing the same data?!
Thanks for your response.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives