Best Of
Re: One of My Stacked Bar Charts Now Shows 120% – How Can I Fix This?
I would suggest reaching out to support. They recently made some updates to chart widgets, and this may be related to that if you never changed anything.
Paul Newcome
Re: Meet Dan Palenchar, our July Member Spotlight! 🎉
Thanks @Ray Lindstrom! Appreciate the kind words :)
Re: Meet Dan Palenchar, our July Member Spotlight! 🎉
Way to go, @SoS | Dan Palenchar! From School of Sheets to Life's a Beach to traveling abroad. Congratulations on your accomplishments, and thanks what you do for the Community! I'll be keeping an eye out for your videos next time I'm searching for a solution.
Another great spotlight. Thank you @Alison C.!
Ray Lindstrom
Re: Sync Automation Edits Across Multiple Sheets
Happy to help!
Yes, that's true for most businesses, and that is also why I don't recommend almost any 3rd-party tools/services, but this gets my stamp of approval. 😉
✅ 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: Sync Automation Edits Across Multiple Sheets
Hi,
I hope you're well and safe!
I agree, and in the meantime, here's a possible workaround.
I'd recommend the fantastic add-on, which makes this possible (+ many other features).
SSFeatures from the brilliant Nathan. @SSFeatures
Would that work/help?
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD
✅ 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: Meet Dan Palenchar, our July Member Spotlight! 🎉
What a great read, I echo @Isis Taylor, very inspiring!
Protonsponge
Enhancements to the Settings panel in new views, now generally available!
July, 22, 2025
The Settings panel in the new views makes it easier for users to review, manage, and update all sheet settings in one place. With this release, users can now do the following from the new views directly:
- Set and manage Start Date, End Date, Dependencies, and % Complete for the sheet
- Set Start of Fiscal Year and Start Day of Week, and configure Working/Non-working Days
- [All new] When using a milestone-only timeline view with only one date column, users can choose which date column is mapped as the Start or End Date
To access the Settings panel, click the gear icon in the top-right corner of the toolbar in table, board, or timeline view. Learn More
Note: The ability to configure resource management settings in the Settings panel is not included in this release.
Environments availability: Commercial US, Commercial EU
Plan availability: Pro, 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: 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å