Exporting group members
I'm wanting to do a review to make sure I have everyone placed in the right buckets. I can dump a user list but there's no group membership details included. I don't see any automated way of dumping group members to CSV for review. The best solution i found is stupid -- open each group and copy-paste the html into excel and then extract emails that way to cross-reference.
Is there a smarter way I'm not aware of? Thanks!
Answers
-
Amit Wadhwani ✭✭✭✭✭✭
The only way I could think of is using Smartsheet API. This particular action is referenced athttps://smartsheet.redoc.ly/#operation/get-group
You do not have to be a programmer to do this. You can use Postman to run the API and get the desired result. Let me know if you would to know how this works.
BR
Amit Wadhwani,Smartsheet CoE,Ignatiuz Software, Exton, PA
Best Regards
Amit Wadhwani, Smartsheet Community Champion
Smartsheet CoE,Ignatiuz Software, Exton, PA
https://www.linkedin.com/in/amitinddr/
Did this answer help you? Show some love by marking this answer as "Insightful" or "Awesome❤️" and "Vote Up⬆️"
Categories
You would use the below for Jan 2023 and adjust the month and year numbers accordingly for each of the other months.<\/p>
=IF(AND(MONTH([Start Date]@row)<= 1, YEAR([Start Date]@row)<= 2023, MONTH([End Date]@row)>= 1, YEAR([End Date]@row)>= 2023), [$ per month]@row)<\/p>"},{"commentID":387901,"body":"
Lets try a different approach.<\/p>
=IF(AND(VALUE(YEAR([Start Date]@row) + IF(MONTH(Start Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/93527/\") + MONTH([Start Date]@row))<= 202307<\/strong>, VALUE(YEAR([End Date]@row) + IF(MONTH([End Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/93527/\") + MONTH([End Date]@row))>= 202307<\/strong>), [$ per month]@row)<\/p> Basically we are creating a yyyymm stamp from the start and end dates and comparing them to the yyyymm stamp for that year\/month combo. The above is for July 2023 (202307).<\/p>"},{"commentID":387906,"body":"
<\/p>