Best Of
Re: Unhide specific columns on a sheet
This + Grouping Columns is fundamental for the larger sheets, particularly those in finance / budgets which have commonalities across sections and also a lot of helper columns which typically are hidden!
Ide AirTrunk
Re: Help with "Syntax not quite right"
If your formula above works, go for it!
Here's an alternative:
=IFERROR(IF(AND(Hierarchy@row = 1, CONTAINS("Travel Week Start Date", DESCENDANTS(Task@row))), INDEX(DESCENDANTS([Start Date]@row), MATCH("Travel Week Start Date", DESCENDANTS(Task@row), 0)), PARENT()), PARENT())
Shout out if you need any help with anything.
Kelly
Kelly Moore
Re: Community Corner Newsletter [January 2025]
@harocha So happy you were able to join Jumpstart. I hope you found it informative and fun!
Arsineh
Re: Amazing Jumpstart 2025 session!
Glad you joined us and enjoyed it! Thanks for coming and thanks for your lovely feedback! 😍
Georgie
Re: February Question of the Month - Join the conversation and receive a badge
If you could create a new badge in Community, what would it be?
"Multi-tab Master" For those who have 12+ tabs of Smartsheet open at any given time!
Eric B.
Re: February Question of the Month - Join the conversation and receive a badge
I'd introduce a badge for users based on the number of Smartsheet assets they create or own.
Something like Creation Commander
For example, badges could be awarded at milestones such as 10, 100, 1,000, 2,000, 3,000 assets, and so on.
This would be a fantastic way to recognize and celebrate the contributions of our community members in their respective companies.
Michelle Basson
Re: February Question of the Month - Join the conversation and receive a badge
I would suggest a group of people specific to helping others with formula — such as The Formulators!
Bruce Case
Re: Dynamic Dashboard Template Customization
Hi @Rose Howard
In the demo dashboard below, I customized the template to add a filter to select a project name and show the selected projected row data. (In your case, the Project Name would be the Last Name.)
To customize the template, I did the following.
First, I added one sheet and two reports.
Those three are equivalents of one sheet and two reports for the original template's region filter.
The Active Project- Project Filter uses the Project sheet's Max Row Helper column (As shown below) to extract one row to show as a "Filtered Project", as shown in the above dashboard. (The report directly uses the Portfolio Summary sheet's "Project Helper" column, but the column is updated with the Max Row Helper.)
The "Current Filter - Project" report shows the current filter for the project choice, as shown in the top right corner of the demo dashboard.
This "Project" sheet has an identical structure to the Region sheet.
Its form is attached with a web widget in the top middle of the above dashboard.
In the "Portfolio Summary" sheet, I added the "Project Helper" column with a similar formula as the Region Helper column.
=IF([Project Name]@row = "Summary", "", IF([Project Name]@row = INDEX({Project Range Project}, MATCH(true, {Project Range Max Row Helper}, 0)), 1, 0))
So, the whole process is as follows.
- The form in the dashboard adds a project name to the Project sheet.
- The new row will be flagged in the Max Row Helper column.
- The corresponding row with the same project name's Project Helper column got flagged.
- Two reports for a project use the flag to filter a project.
- The dashboard displays those filtered reports.
Current User Approach
Since you know how to use a report to select the current user filter, you just have to create a report with relevant data with the current user filter. (Make sure to set the Viewer Mode to "Their own perspective"
When I log in as "App".
When I log in as "Demo".
Re: Community Corner Newsletter [February 2025]
I am so excited to be part of the most recent class of Community Champions along with my 18 other classmates.
Also - to the community as a whole, I am honored to be able to meet with and help so many of you. If there is every ANYONE who wants to troubleshoot something, review a formula, or whiteboard a solution, I am so happy to meet with you on zoom. My calendar link is in my signature. :)
Re: Core App Skills Badge not visible
:( I heard no more credly, but thought the community badges would continue.
Congratulations though!
KPH