Best Of
May Question of the Month - Join the conversation and receive a badge
Hey Community!
Last month we asked about your desk treasures, and it was a joy to read all the stories behind them. There was a bit of everything — a 3D printed dragon, your kid’s sweet notes, more than a few coffee mugs, and fun coworker gifts (like this wooden frog)! I loved seeing you connect while sharing how much meaning these little objects can hold.
Now, let’s switch it up again. Here’s a fun new chance to earn a badge and get to know your peers along the way.
How would you describe your job to a five year old?
I’m really looking forward to seeing what you come up with! Let's see how you break down your job for the little ones.
Share those kid-friendly explanations in the comments below. ⬇️
About Question of the Month:
We kick off each month with a new question. These monthly ice breakers are just one way to help you get to know your Smartsheet peers and rack up some badges and points in the process.
Everyone who participates by answering the question prior to the end of the month will automatically receive a unique participant badge once the question closes at the end of the month.
In addition to the participant badge, the top three answers based on Community member votes will receive the Top Answer badge. To vote on an answer click on the upvote icon associated with an answer in the comments below. Multiple votes allowed and encouraged!
Rebeca S.
Re: Auto-Populate Data from Master Sheet Based on Textbook Selection (No Automation)
Thank you! I used INDEX MATCH, and it worked perfectly. Appreciate the help.
SNH
Re: Formula for date range after two different dates
You are amazing!! Thank you so much!
mreynolds66
Re: Dashboard - can reduce Rich Text Widget
Hi there,
This bug has been resolved by the dashboard team. Thank you for sharing your feedback and let me know if you're still encountering this issue.
Thanks,
Barak
Barak Schriger
Re: Current User Dashboard Help
Hi @Dana234
To create a dashboard that contains only the current user's information, you add a report to the dashboard that is filtered by the current user.
You need to share both the base sheet and the report with your staff to display the user's information.
In the image below, Juni Miyazaki is accessing the dashboard. So, his "To-Do 4" is displayed.
(Link to the published dashboard. You will see an image similar to the one at the bottom, as you do not have access to the sheet and report.
In the dashboard's Report Widget setting, set the View Mode to "Their own perspective".
Published User's View
Re: Dashboard Rich Text Widget Excessive Vertical Scroll Bar
YAY! It's fixed. My OCD thanks you very much!
Re: Dashboard Rich Text Widget Excessive Vertical Scroll Bar
Hi there,
This bug has been resolved by the dashboard team. Thank you for sharing your feedback and let me know if you're still encountering this issue.
Thanks,
Barak
Barak Schriger
Re: Sort Card View to have High Priority on the top
Hi @kowal!
Card View doesn’t currently support sorting cards in a lane by priority or flag. That said, there’s already a product idea for this feature here:
👉 Quick Sort Card View (Sheets and Reports)
Feel free to add your vote and comment to support it!
Cheers,
Isaac.
Isaac A.
Re: Two Sheets in One Report using same column
It sounds like you want to be able to change the date in Sheet 2's column formula, and specifically to do it inside a report. It sounds like you could create on your sheet 2 a "Manual Override" column, and then call that "A" (so it matches the Sheet 1 column name). And then somewhere on your Sheet 2, you can add your Index/Match to pull the date over, but add a clause to consider the manual override data:
=IF(ISBLANK([Manual Override]@row, INDEX/MATCH FORMULA TO PULL YOUR DATE, [Manual Override]@row)
That will make it possible for your date columns on both sheets to be manual entry. What other reports, automations, etc. you may have produced on that existing column "A" on Sheet 2 might need some retooling though.
Good luck!
Kerry St. Thomas