Best Of
Re: NEW! Timeline view widget in dashboards
@Paula Grahame — Thanks for sharing your feedback! We're tracking a similar request from other customers, the ability to restrict the date range for the displayed timeline on a dashboard. Stay tuned!
Re: 承認者の名前取得方法について
Webhookのところが面倒なので、定期実行にすれば少し楽になると思ます。
Cell Historyはなくなるものでないので、想定されている利用ケースは、後から承認者を確認するといった監査などの目的でないかと推察されれ、一日に一回、実行する、といった形にすればよいかと思います。
必要であればお手伝いしますので、私のプロフィールにあるメールアドれるにご連絡ください。
Re: Portfolio Level Week-to-Week Changes
Hi @Nikki G ,
We ran into this same challenge and I built a solution that works well across multiple programs. Here's how we approached it:
- Snapshot Sheet Method – I created a weekly snapshot sheet that logs key portfolio metrics (like % Complete, At-Risk Projects, Delays, etc.) every Friday using a helper workflow and a simple "snapshot row" per project.
- Automation – Smartsheet automation copies data into the snapshot sheet at a set time weekly, so it’s hands-off once built.
- Portfolio Rollup Dashboard – We pull the data into a dashboard showing week-over-week changes using chart widgets and summary reports for visual tracking.
Bonus: If you're using Control Center, you can template this process and apply it portfolio-wide easily.
Re: Translating Formula to Smartsheet
Hello KPH,
So…. I should probably be barred from sending updates on Monday mornings. You are absolutely right and I haven't been looking at this right, till now. I'm going to go do this a little more correctly and I'll get back to you. Sorry, but thank you for sticking with me!
Re: Insert image to cell in batch
@LaurenLong Not sure if you still need to do this, but I found this post and figured I would comment. This script worked for me using python/pandas and the API - only one photo per row and all my photos in a single photo:
Re: August Question of the Month - Join the conversation and receive a badge
Honestly, it’s the Community itself. I used to feel like I was alone with my enthusiasm for Smartsheet, until I discovered the Community. The diversity of backgrounds, industries, and use cases is incredible. It’s inspiring to see how solutions often come from people outside my field who’ve tackled similar challenges in completely different contexts.
The collaborative spirit here is unmatched. Whether it’s a quick tip, a deep dive into a formula, or just some good old-fashioned “nerdy talk,” there’s always someone ready to help, share, and uplift. The responsiveness is remarkable too.
This platform has become part of my daily routine, and it’s comforting to know I’m not alone. I’ve found my people.
MeganNelson
Re: August Question of the Month - Join the conversation and receive a badge
Seconding Naeem and Rebecca's sentiment about posters commenting that their problems were solved from threads in Community! It's really nice to see the lasting impact of things written here.
meagans
Re: August Question of the Month - Join the conversation and receive a badge
I agree with this! It is so helpful to go back and see threads on problems that others are working together to solve that I just stumbled into myself.
rebecca.collins
Re: August Question of the Month - Join the conversation and receive a badge
The best thing I've seen on the Smartsheet Community is not one particular post, but instead a theme of posts. That theme would be the posting of what people are proud of and delighted to share. Whether it be about their kids, pets, success(es), hobbies, traveling, etc.. It brings me joy to see what brings others' joy.
Ray Lindstrom
Re: August Question of the Month - Join the conversation and receive a badge
I'm adding my vote to "Sense of Community" too!
Paul Newcome
