Best Of
Re: New Member Here!
Welcome to the Smartsheet Community @kaithumb, hope you've been enjoying these first few days! We're all here if you have any questions. 😄
Rebeca S.
Re: Sumifs & multi-select dropdown referencing other sheet
Try this:
=SUMIFS({Branch HC Column}, {Branch Column}, @cell = PARENT(Branch@row), {EMP Group}, HAS([Affected Employees]@row, @cell))
Paul Newcome
Re: Help with SUMIFS formula
@punitjha Smartsheet's SUMIFS can sum horizontally.
@Paul69g Give this a try instead:
=IF(AND([Column10]4 = [Today's year]#, [Column10]3 >= 1, [Column14]3 <= 6), SUM([Column10]@row:[Column14]@row))
If the above does not work, please provide a screenshot.
Paul Newcome
Re: July Question of the Month - Join the conversation and receive a badge
Hi there, dear all,
My name is Hans and I am a German. Have been working more than twenty years in the tough automotive industry as a project manager and also accomplished at this time to be Smartsheet certified and was teaching my fellow coworkers in project management as well. Now I am 66 years old. But when I retired then it turned out that my wife got sick, handicapped to a 100% degree and sits now in a wheelchair. At the same time my almost ninety-year-old mother broke her hip. I took her with me home and care now also for her as well. This was and still is a big challenge for me. Nonetheless, I think I manage everything pretty well by caring for them and do laundry and run the household and so on. They are my first priority and neither of them had to go to a nursing home! First goal accomplished!
Handling two severely handicapped people took a lot of my energy. T
o still stay sane I needed to do something else purposeful too. I needed mentally distraction. So I decided to write a book. A textbook about Smartsheet and WBS (Work-Breakdown-Structure), embedded into a novel. This was already forever always my dream in my life! Easter this year 2025 I released my e-book at Kindle Direct Publishing. It has 416 pages, is written in German language, and you can look it up at Amazon when you there search either for “Smartsheet” or my name “Hans Porzel”. Second mission also accomplished!
Happy smiles!
Here a few pictures so you may get a better idea where I am talking about.
Hans1958
Re: Smartsheet recognized as a Customers' Choice in the Gartner® Peer Insights™ + Giveaway
I use Smartsheet at work all the time, and there are a ton of projects that I could mention. Instead of work, though, I'm gonna highlight a personal use.
Almost a year ago, my partner and I bought a house! As everyone knows, with a new house comes new challenges. We planned everything out, did a LOT of research with our finances, and after a few months, something was just off. So, to Smartsheet I went! Using Smartsheet, I redid all things budgeting and expenses, breaking everything out both individually and through shared expenses. Thanks to this, we were able to confidently adjust, and everything has been smooth sailing since. It seems simple, but it's lifted a HUGE stress from our lives.
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