Best Of
Re: Show Off your Smartpets
Super Fly is such a fun name, I love it! He looks super sweet, and I'm so happy to hear he's so full of energy now. πΆπ
Rebeca S.
Re: Formula for Month in words
For the full month name such as "January", you would use this:
=MID("01January02February03March04April05May06June07July08August09September10October11November12December13", FIND(RIGHT("0" + MONTH([Refund Deadline]@row), 2), "01January02February03March04April05May06June07July08August09September10October11November12December13") + 1, FIND(RIGHT("0" + (MONTH([Refund Deadline]@row) + 1)), "01January02February03March04April05May06June07July08August09September10October11November12December13") - (FIND(RIGHT("0" + MONTH([Refund Deadline]@row ), 2), "01January02February03March04April05May06June07July08August09September10October11November12December13") + 1))
For a three character such as "Jan":
=MID("12JanFebMarAprMayJunJulAugSepOctNovDec", MONTH([Refund Deadline]@row) * 3, 3)
Paul Newcome
Re: Introducing the PeerConnect Program!
Loving all the questions about Peer Connect! I'm pretty sure the program is still up and running, @Protonsponge and I are game planning today since we'll be hanging out together at ENGAGE next week β if you spot us, come say hey! And here's the fun part: if you see me at Engage and ask me about Peer Connect, I've got a special sticker for you! We absolutely love this program and the amazing connections that happen when our community comes together.
Re: What us the maximum number of forms one could make for a sheet?
You can give each site a different link to the same form with some preset values
https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values
Paul H
Controlling record visibility in reports using Smartsheet Groups
This solution allows you to combine the "Current User" filter and Smartsheet Group membership to filter records based on who is a member of a Smartsheet Group.
Solution overview
- Python
- Create scheduled task to run daily Python script that pulls all Smartsheet groups and group members and saves as CSV on SharePoint site.
- DataShuttle
- Schedule DataShuttle to load "Group-Member" CSV into "Groups" DataTable
- DataTable
- Create DataTable Connection to load "Groups" DataTable data into "Group-Members" sheet.
- Group-Members sheet
- The "Group-Members" sheet will contain a record for each Group-Member combination. There will be one record for every member of every group.
- DataMesh - Group names to Group Summary sheet
- Create DataMesh to transfer Group names from "Group-Members" sheet to "Group Summary" sheet.
- Group Summary sheet
- The "Group Summary" sheet will contain a list of every group and all members. There will be one record per Group.
- On "Group Summary" sheet use a Join Collect formula to gather all the group member emails into the "Group members - Text" field.
- =IF([# of members]@row <= 30, JOIN(COLLECT({Smartsheet Group List - Member email}, {Smartsheet Group List - Group name}, [Smartsheet group name]@row ), ";"), "Too many members to display")
- The Group members will appear as emails separated by ";"
- DataMesh - Convert member emails into Contacts
- Create a DataMesh to transfer the text group members into a Contact column called "Group members" on the same "Group summary" sheet. The text emails will be converted into Contacts.
At this point you will now have a automatically updating list of groups with their members as Contacts in Smartsheet. You can you DataMesh or cros ssheet references to pull the Group members onto other sheets using the Group name.
Tools required
- Computer to run scheduled Python query to pull Groups and Group members and save it to a SharePoint location
- SharePoint location to save the Group-Member list
- Smartsheet API access
- DataShuttle
- DataTable
- DataMesh
I hope this is useful to you.
Neil Egsgard
Business Solutions Architect
Southern Alberta Institute of Technology
Neil Egsgard
Re: Meet Angela Breslau, our October Member Spotlight! π
Big congratulations @AngB789, such a well-deserved Member Spotlight! π
I knew you were amazing, but now I know you are really coolβdemolition derbies look awesome. π We are so lucky to have you as one of our Community Ambassadors, thank you for all you do to in the Community. Looking forward to seeing you at ENGAGE!
Rebeca S.




