Best Of
Re: CONTAINS to check box if cell has certain email domain
Here is a way to do it but it is a bit janky.
Add a autonumbering column to the sheet.
Create a data shuttle to export the autonumber column and the contact column from your sheet to a csv file every 15 minutes.
In the csv file the contact column will be the email address of the contact.
Create a data shuttle to import the csv file to the sheet every 15 minutes using the autonumber column as the key and import the email address to a helper column.
Then you can user your formula on the helper column.
/marc
Re: What is the difference between the Card View and the Board View?
Board View doesn't show attachments in comments added in Card View. Created and/or modified date & time stamps are also incorrect and showing for some other time zone than my own. How did obvious things like this slip through the cracks?
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.



