Best Of
Re: duplicate entry checking 2 sheets
Try something like this.
1️⃣ . Add an Autonumber column (if you don't have one already). I've named mine RowID.
2️⃣ . Add a column called Duplicate and make it a Flag type column.
3️⃣ . Add the below formula and make it a Column Formula.
=IF([Invoice Number]@row <> "", IF(RowID@row <> INDEX(COLLECT(RowID:RowID, [Invoice Number]:[Invoice Number], [Invoice Number]@row ), 1), 1, 0))
This formula will flag any duplicates after the first.
Did that work/help?
✅ Remember! Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏
Andrée Starå
Re: July Question of the Month - Join the conversation and receive a badge
One goal this year was to study for and complete a new certification that would advance a stackable certification that is in a renewal path. It is going very well, and the updated material has been a great refresher.
ss_innovation
Re: Populate cell with current date and time
You can look at the individual checkbox cell's history, but that doesn't really lend itself to scalability. Automations only record a DATE, which obviously won't work for your use case. The workaround I've used in the one case I had to record time is simliar to described here - it isn't pretty, but it works. I'd be delighted if anyone else can offer something that's a bit more elegant than this trashfire. 😀
1. The sheet on which this checkbox appears will need to have some kind of a unique identifier for each row. If you already have something you can use (like an order number or an employee ID or something that shouldn't be repeated on the sheet EVER), great. If not, add an Autonumber column.
2. Create a COPY ROW automation that is triggered when your box is checked. Copy that row to a new sheet whose entire purpose is to create this timestamp. On that NEW sheet, be certain a Created Date column exists. (If it already does on your main sheet, you'll need to test and possibly play with column names and/or types - you're trying to capture when the row is created on the NEW sheet and not the original sheet.)
3. On the NEW sheet, split the date and time of the Created column into separate cells with Text/Number type - use formulas like =LEFT(Created@row, FIND(" ",Created@row)-1) to accomplish this. Only column type Text/Number will retain the timestamp, so you're converting the data type by doing this split.
4. You'll then be able to look up that new "timestamp" cell using your unique identifier from #1 to pull the time over. You can use the TIME formula to do whatever calculations you need to.
Kerry St. Thomas
Group by more column types in timeline view, now generally available!
July, 23, 2025
We expanded the grouping options in timeline view to support even more column types. Now, in addition to single-select dropdown, single-select contact list, and symbol columns, we also support level 1 and level 2 timeline view grouping by text/number, checkbox, and date columns. This means users can now group by almost all column types in timeline; the only exceptions are duration, multi-select contact, and multi-select dropdown. Learn More
Environments availability: Commercial US, Commercial EU
Plan availability: Business, Enterprise, Advanced Work Management
Subscription Model Availability: Legacy Collaborator Model, User Subscription Model
Stay informed by subscribing to receive product release updates for curated news of recently released product capabilities and enhancements for the platform of your choosing, delivered to your inbox. As new releases occur, you will receive a weekly email with news of what's released every Tuesday.
Lekshmi Unnithan
Re: Long Forms and the ability for submitters to Save as Draft
Excellent!
You're more than welcome!
✅ Remember! Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏
Andrée Starå
Re: Registration is open! Come be in community at ENGAGE 2025
Hey Ray! I believe once you've completed the registration process, it will then bring you to the hotel portal which shows the ones with discounted rates.
Alison C.
Collections in Favorites now generally available!
July, 23, 2025
Staying organized just got easier with collections in Favorites! Save an entire collection to your Favorites list to easily find what you need faster and refer back to it anytime. Learn More
Environment availability: Commercial US, Commercial EU, Commercial AU
Plan availability: Enterprise and Advanced Work Management
Subscription Model Availability: Legacy Collaborator Model and User Subscription Model
Stay informed by Subscribing to receive product release updates for curated news of recently released product capabilities and enhancements for the platform of your choosing, delivered to your inbox. As new releases occur, you will receive a weekly email with news of what's released every Tuesday.
Re: Meet Dan Palenchar, our July Member Spotlight! 🎉
Thanks so much @Alison C. for the post and everything you do for the community!
I'm looking forward to connecting with more of the community, my line is always open for any reason.
Meet Dan Palenchar, our July Member Spotlight! 🎉
Hip, hip, hooray! 🙌🏻 That’s what we say when we get to introduce you to amazing Community Members each month - and this time, we’d like you to meet @SoS | Dan Palenchar.
Dan is the founder and CEO of School of Sheets Solutions Consulting, a Smartsheet Aligned Solutions Partner, and lives in California. With a background in scientific research, Dan initially used his advanced Excel training to take on Smartsheet architecture work at a healthcare agency. He quickly fell in love with the balance of art and science required, finding great satisfaction in solving complex technical challenges. This is what ultimately led him to dedicate his career to Smartsheet Solution Architecture.
“I really love the core platform. It’s extensive and robust by itself, and the more you know how to use it, the more remarkable it becomes. I appreciate how other tools like Control Center, Data Mesh, and Dynamic View solve the inevitable challenges with operating at scale, but they have to rely on a solid foundation.”
His favorite solutions include Dynamic Dashboards, Automatic Duplicate Removal, Multi Colored Bar Charts, and what he deems as the “People’s Choice”: Automatic Document Generation Workflow. Click above to watch Dan’s demo to get your own personalized walkthrough!
When asked about the Smartsheet Partner Program, Dan says he’s proud to have been a partner for over the last 5 years, and feels that it’s allowed him to not only run his own business but to grow and go after bigger and bigger problems. “For anyone who is offering Smartsheet Professional Services, not being a partner is like being on hard mode,” he says. “The program gives you credibility, recognition, access to customers, training and incentive to do the work you already do.”
Community has also played a role in Dan’s growth, and he says he’s learned from it throughout each chapter of his Smartsheet story - from newbie to expert. “As I’ve moved from a ‘student’ to an ‘educator,’ I continue to learn from the Community by answering questions which keeps me sharp both technically and by understanding what people want out of Smartsheet,” he says. He also recognizes @Paul Newcome's efforts on the platform, finding his support incredibly helpful.
Looking ahead, Dan hopes that School of Sheets continues to grow and help others, and has found making YouTube videos about Smartsheet to be an effective way of reaching a broader audience. “I have always loved to help others…I hope over time and with enough dedication, the School of Sheets YouTube channel will delight millions of people,” he says.
Dan says he doesn’t do well sitting in one place for long, and spent eight months in Africa last year! When he’s in California, he’s an avid beach volleyball player and the proud founder of the Life’s A Beach Volleyball Club, providing training programs, games, leagues and tournaments with a focus on inclusivity, community engagement and fun. He also loves music, and plays several instruments.
Thank you Dan for all that you do!
—
👉🏻 Do you know someone in the Community who should be next month's Member Spotlight? Nominate them here. (NOTE: Any Community member can nominate someone else in the Community).
Alison C.
Re: Provide users with the ability to Print a Grouped Report
I agree, and I know it was planned. I think it will come when we've transitioned to the new framework more completely.
✅ Remember! Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏
Andrée Starå





