Best Of
Re: CONTAINS to check box if cell has certain email domain
Thanks for replying. It displays as the name for 2 companies and hovering over displays both name and email. for the other 2 companies, it displays the email address.
Re: Help with SUMIF formula
I would suggest using a bit of a different approach. If my start date is 12/31/25 and my end date is 1/1/27, I won't get counted for March of 2026. The start month is greater than 3, the end month is less than 3, and neither of the years match 2026.
My recommendation would be to use the DATE function instead and compare the start date to less than the first of the next month and the end date greater than or equal to the first day of the month.
May 2026 would look like this:
=SUMIFS({Allocation}, {Resource}, @cell = Resource@row, {Start Date}, @cell < DATE(2026, 06, 01), {End Date}, @cell >= DATE(2026, 05, 01))
June 2026:
=SUMIFS({Allocation}, {Resource}, @cell = Resource@row, {Start Date}, @cell < DATE(2026, 07, 01), {End Date}, @cell >= DATE(2026, 06, 01))
Paul Newcome
Re: I'm embarrassed to ask: How do you write an API
If you're interested in APIs, I recommend starting to learn how to use curl. There are also automation platforms like N8N which make http requests very easy to aggregate data and move to other locations.
Smartsheet also recommends using postman to use their API collections and how they work. I recommend browsing through the smartsheet API catalogue
SteyJ
Re: Public sector - public records requests
Hello there!
https://www.youtube.com/watch?v=1z_CuFgwjHw
In this YouTube link, you will find how to export
This is the standard way to pull a complete record of a project for compliance.
Excel File: Contains all the sheet data, Cruicially, this excel file includes a "Comments" tab that logs every comment, who made it and the timestamp
Sheet Data: The rows and columns of your project plan.
Attachments Folder: A separate folder containing every file ever attached to the sheet, organized by Row ID.
How To do it:
In your workspace or sheet list, right-click the Sheet(or Workspace)
Select Request Backup(or "Schedule recurring backup", if you want it regular).
Check the box for "include attachments"
Thanks,
Mohammad Abdul Samad
abdulsamadm528@gmail .com
Re: No notifications - intake form
This one was key for me when I was running into the same issue
Trieken
Re: Helping people realize Smartsheet value 📈
Hello Everyone,
We onboard new Release List Smartsheet users through a structured process designed to ensure a smooth transition and effective adoption. This includes:
- Adding users to our dedicated Microsoft Teams site for collaboration and resource access.
- Scheduling Instructor-Led Training (ILT) sessions to provide comprehensive guidance.
- Conducting personalized 1:1 walkthroughs of key processes and workflows.
- Providing Job Aids and Quick Reference Guides for easy, on-demand support.
- Offering access to a custom-built Copilot Agent, enabling users to ask questions and receive instant assistance related to our processes and their role.
- Maintaining a dedicated Q&A channel and an FAQ repository, ensuring users have quick access to common questions and answers.
DaniSap
Re: Helping people realize Smartsheet value 📈
This was a while ago, but I helped revamp the project workflow for a team. They were handed a process that was ultimately created for people that were no longer around and most of the process did not serve them or what they needed. I sat down with different team members to understand what they were doing on a day-to-day and what would be most helpful for them and simplified the process to make it easier and more helpful for the team. They were extremely grateful and made it clear that it was me taking the time to understand them and what they do that made a difference. One of the quotes I received from possibly the biggest skeptic on the team:
"Smartsheets has gone from being an awkward, forced, and frustrating tool that doesn't serve our creators to now being a powerful, data driven, efficient tool that our whole team can use in whatever way is best for them. I'm personally so excited to learn more about how we can use it moving forward and for the hours it's going to save us."
Re: Helping people realize Smartsheet value 📈
When I first discovered Smartsheet, and all that it was capable of, I immediately set out on a journey to introduce it to my school district (this was back in 2017). While this was a huge undertaking, I knew that it would be worth it in the end. At first, the struggle was always helping teams understand why Smartsheet was more than "just another spreadsheet", once that hurdle was cleared, I set out to develop a full-scale New Hire Induction solution. This solution has evolved multiple times over the years and I am very proud of the current status of this solution. Once people were able to experience first-hand just how much time could be saved by using Smartsheet, they were hooked. Since we are a K-12 Public School District, we do tend to utilize Smartsheet in many different ways across multiple departments, but I believe that is why Smartsheet is such a valuable tool for us. Especially now that we, like many other school districts across the nation, are experiencing declining student enrollment which has a direct impact on funding for the district. Another impact is that we are experiencing is when folks retire or resign from our district, more often than not, their positions are not being backfilled. This results in job duties needing to be absorbed by remaining staff, which continues to put a strain on everyone. Smartsheet, with its powerful capabilities, has been a game-changer for us during these times.
The main way we have handled barriers to adoption of Smartsheet is by creating a dashboard for our licensed users, providing them with initial onboarding training, and then providing them with the resources within our district for support with their department's adoption of Smartsheet. I have also been working on developing our internal support team (our power users) member's knowledge and ensuring they know and understand the importance of taking the time to listen to our newest licensed users. This helps us with meeting them where they are at with their learning and implementation. I love hearing about their successes, and even their pain-points, then helping to guide them on ways to fix and adjust their solutions to eliminate any remaining pain-points. Watching our departments staff members change their mindset from "this is just another spreadsheet", to "wow, this is so easy and fun and is saving me a ton of time in my day", are just a few examples of why I love working with Smartsheet and sharing with everyone and helping find their own success with using Smartsheet in their department.
Re: On enterprise plan with SSO, can a non-member edit a specific shared sheet indefinitely?
Great questions! Here’s what’s happening:
- When someone in your domain edits a sheet but isn’t a licensed user, they should appear as a provisional member in Admin Center—but this isn’t instant. It can take up to 24 hours for the sync to happen.
- If your settings prevent provisional members from auto-converting, they’ll keep access until the next quarterly true-up. After that, they’ll lose edit rights unless you convert them to a licensed user. You won’t be able to re-share with edit permissions unless they become licensed.
- On Enterprise plans, view-only access can be indefinite, but edit access requires a license. Provisional members are temporary editors until renewal—there’s no way to keep edit access indefinitely without converting them. This can be bypassed if you utilize Dynamic Views.
AngB789
Re: January Question of the Month - Join the conversation and receive a badge
I’m excited to put into practice in 2026 the work I’ve been building over the past week — turning my Smartsheet Admin API data extraction into a fully automated workflow.
I’ve been developing Python scripts to extract and analyze admin data such as user access, group governance, seat utilization, and workspace/asset usage. In 2026, I plan to publish this as a fully working GitHub project and set it up with GitHub Actions to run on a daily schedule, automatically refreshing insights without manual effort.
At the moment, the setup requires manual updates of session cookies and XSRF tokens due to server-side constraints, but I’m looking forward to refining this further and exploring more sustainable approaches.
The goal is to make governance and visibility proactive instead of reactive, giving teams and leadership a clear view of adoption, usage trends, and optimization opportunities over time.
Really looking forward to refining this and learning from others in the community too!



