Best Of
Re: I need to Sum a column from a reference sheet and display the number in my primary sheet
Hi @Jewelle W
You can use the SUMIFS function.
=SUMIFS({TS WIP Incurred Hours}, {TS WIP : Project Name}, [Project Name]@row , {TS WIP : Phase Name}, [Phase Name]@row , {TS WIP : Task Name}, [Task Name]@row )
By the way, the correct format for COUNTIF(S) and SUMIF in your formula is as shown below.
=COUNTIF({Incurred Hours}, {Phase Name} = [Phase Name]@row )
=COUNTIF({Incurred Hours},>0, {Phase Name} , [Phase Name]@row )
COUNTIFS(range1, criterion1, [range2, criterion2, ...])
=IF([Budget:]@row > 0, SUMIF({Incurred Hours}, {Phase Name} = [Phase Name]@row ), "")
=IF([Budget:]@row > 0, SUMIF( {Phase Name}, [Phase Name]@row, ({Incurred Hours} ), "")
SUMIF(range, criterion, [sum_range])
Re: Display all column values on a Dashboard
- Create a Report:
- Go to Browse > Create > Report.
- Use a Row Report.
- Set the source sheet to the one with your desired column.
- Under Columns to Display, include only the column you want to show.
- Use filters if needed (e.g., exclude blanks or duplicates).
- Save the Report.
- Add to Dashboard:
- Open your Dashboard.
- Add a Report Widget.
- Select the report you just made.
- Resize/format as needed.
✅ Best method for listing multiple values directly from a column.
Naeem Ejaz
Smartsheet recognized as a Customers' Choice in the Gartner® Peer Insights™ + Giveaway
Community, who doesn’t love to start the week with good news? We certainly do!
Smartsheet was just recognized as a Customers' Choice in the Gartner® Peer Insights™ Voice of the Customer for Collaborative Work Management. Not only that, but this is the third time in a row — how awesome is that!? 🎉
We’re excited to celebrate with you with the chance to win a Smartsheet-McLaren branded backpack!
We're especially grateful for this recognition because it comes directly from customers' feedback! Every day, Smartsheet users like you, across different industries, teams, and regions, are collaborating, pushing what's possible, and creating amazing solutions.
Principal Program Manager, IT Function, Services Industry
With such great news, of course we want to celebrate together with you. Participating is super simple, just answer the prompt below and you’ll be automatically entered to win Smartsheet swag.
Tell us: What's one clever or unique way you've used Smartsheet that you're proud of?
You use Smartsheet in such a vast variety of ways, to make things flow at work, at home or in your community. We can't wait to hear about the ingenious ways you're putting it to use and the outstanding solutions you’re developing!
You've got time to participate until Monday, August 11 at 5pm PST.
Full giveaway rules:
Rebeca S.
Re: Rich Text Formatting for Conversations/Comments
Format text (e.g. Bold, bullets, automatic numbering) in conversation and in partial area within a cell.
ath
Re: Parent status based on children
You need a nested if formula
=if(contains("Blocked", children()),"Blocked", if(contains("In Progress", children()),"In Progress", if(contains("Completed", children()),"Completed", "Not Started")))
Samuel Mueller
Re: July Question of the Month - Join the conversation and receive a badge
The fulfillment of my goal came early in the year when my aunt, who lives in Italy, was turning 100. I was the only person in the whole family (living in the U.S.) who hadn't travelled to Italy. It was quite embarrassing when the generation younger than me have been there and 1 young cousin splits her life between the two countries.
When my brother and his wife commented they were thinking of going for the birthday celebration, I threw caution to the wind and said let's make it happen! This is so unlike me, not worrying about expenses and all the other details. I actually didn't give myself enough time to worry. We decided to go in Dec for 2 weeks the latter half of March.
It was spectacular! Got to see a lot of family, the towns/houses where each grandparent lived, the Church the family financially supported over the centuries (since c. 1400s), the plaque dedicated to my maternal great-grandfather for all his contributions and the mountain that was in my paternal grandfather's name for decades/generations (after he won it back in a card game when his father lost title 😊).
And then there were all the regular, historical sites to see, participating in the Pilgrimage of Hope and wondering who was going to be the next Pope. Thankfully, we left just as the conclave started. We got to see everything without the major crowds.
It was a dream of a lifetime!
God is good!
Kathy PPT
Re: SmartU New Offerings - Smartsheet Builder Path & more!
Thank you for the clarification and encouragement for becoming a Smartsheet Certified Professional. I have already looked at the presentation part. The cost of just an exam is usually within reach, however discounts are always welcomed. I am looking forward, in that nerdy twisted way, of taking on the challenge.
Meg Young
Meg Y
Create more Column Links per sheet
July 07, 2025
This release adds pagination to the Data Links panel so users can create additional column link configurations.
Previously, users could only create 20 inbound and 20 outbound column link configurations per sheet. Limits are being increased as follows:
- Inbound column link configs: 20->400
- Outbound column link configs: 20->250,000
Environments availability: Commercial US, Commercial EU
Plan availability: Pro, Business, Enterprise, 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.
Danielle Wilson
Re: SmartU New Offerings - Smartsheet Builder Path & more!
Thank you so much for the clarification and thoughtful advice—it’s incredibly helpful!
I’ll definitely keep an eye out for the auto-notification from SmartU regarding the Builder Credential in September. And I appreciate the direct contact just in case anything slips through the cracks.
Your insight about the Professional Certification and its evolved structure really resonates. I’ll shift focus accordingly and continue sharpening my Control Center skills in the meantime. Excited to see how these credentials reflect the value Smartsheet professionals bring beyond just product mastery.
Thanks again, and I look forward to staying connected!
Jacob A
Re: SmartU New Offerings - Smartsheet Builder Path & more!
@Rhonda Keller, SmartU Thanks for the added clarification because like @Jacob A , I had System Admin and Control Center next on my bingo card.
Isis Taylor