Best Of
Re: Question on status rollup using IF COUNTIF formula
The initial issue is that the comma after "Complete" at the end needs removed.
You could also have it count the same as "Complete" by using an OR function like so:
=IF(COUNTIF(CHILDREN(), OR(@cell = "Complete", @cell = "N/A")) = COUNT(CHILDREN()), "Complete", IF(COUNTIF(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started", "In Progress"))
Paul Newcome
Re: Formula help to convert from total days to business days
How about this:=IF(AND(NOT(ISBLANK([Construction in Progress Date]@row)),
NOT(ISBLANK([Into Pending Lateral Date]@row))),NETWORKDAYS([Construction in Progress Date]@row, [Into Pending Lateral Date]@row),"")
It ensures both start and end dates are present.
Only then computes business days, otherwise, returns a blank (""), not 1 or error
=Chris Palmer
Re: FORMULATE FOR DAYS
@KempenUSA you want an if then where your if check is whether dept date 2 is blank.
=if(isblank([DEPT DATE-2]@row),NETWORKDAYS([DEPT DATE-1]@row, [RETURN DATE TOTAL TRAVEL DAYS]@row), NETWORKDAYS([DEPT DATE-1]@row, [DEPT DATE-2]@row))
prime_nathaniel
Re: Welcome to the Digital and IT Portfolio Management Community!
Hi, I've been using Smartsheet for over 2 years.
The primary use for Smartsheet at my company is project management, but it is quickly spreading to other areas. Our IT team uses JIRA, tableau, Power BI, etc so I am interested in learning how well Smartsheet integrates with those systems
Isis Taylor
Re: How to automatically change a status cell color due to other columns being changed
I think I worked this out, by using a combination of automations for each change and then conditional formatting once the change has been seen.
This is how I did it:
1.Status column using dropdown with the different column names that will be checked off.
2. Automation to change the value of the Status column as the task columns are changed from red X to green Tick.
3. Conditional formatting to change when different status name is used.
Gary Collins
Re: Welcome to the Project Management Office (PMO) Community!
I've been using Smartsheet a little over 2 years. Currently my team uses it to manage projects and to report out on our portfolio to leadership. However, as I have been tasked with increasing engagement within the organization, I build out processes for invoicing, vendor management, and compliance operations. I would like to know what types of reports/dashboards other people are using on the project level.
Isis Taylor
Re: Welcome to the Project Management Office (PMO) Community!
Hello PMO Professionals!
In this day and age where the general opinion is that AI will take over the world, it's great to be apart of a community that can connect, share ideas, and where we can actually learn from other human beings.
I'm Marcé Holzhauzen, based in Port Elizabeth, South Africa 🗺️. I’m a coffee enthusiast ☕, self-diagnosed chocoholic 🍫, and total Smartsheet nerd 🤓. I'm part of Prodactive Limited, where I get to combine creativity, structure, and strategy as a Smartsheet Solution Architect. I’m passionate about building solutions that not only look good but drive real results. ⚙️✨
How long have you been using Smartsheet?
I’ve been actively working with Smartsheet for over 6 years, and it’s been an incredible journey watching how the platform continues to evolve.
How are you using Smartsheet?
My very first engagement with Smartsheet was in 2017. It was a really cool tool that we used exclusively at C-suite level. Fast forward 2 years, and a new company, and we're using Smartsheet as the backbone of our operational functions. I joined Prodactive as a full time Solution Architect in 2024 and have never looked back.
I get to work with clients across multiple industries to design and deliver bespoke Smartsheet solutions that solve real business challenges—whether that’s improving visibility, streamlining processes, or empowering teams with tools they actually enjoy using. It’s all about understanding where the pain points are and building something that transforms how they work. 🚀
What would you like to learn from your peers using Smartsheet?
I’d love to hear how others are navigating change management, adoption strategies, and building in governance without slowing momentum. Always curious to see how others are stretching the platform in creative ways!
Looking forward to e-meeting and connecting with all of you and learning from everyday heroes!
MarceHolzhauzen
Re: Community Corner Newsletter [May 2025]
Hello! Yes, Spring has Sprung! I moved to California 2 years ago from Michigan, so Spring starts earlier here. So amazing. I am not sure I am cut out for cold any more!
Welcome to all of the new Community Members!
I really like table view, and since it is relatively new still, I am still learning, and growing with it. Excited to see where it leads!
Happy May, Everyone!
Paul.Woodward
Re: SmartStories - Celebrating 10 Years of the Smartsheet Community
This is awesome! I love all the comments mentioned and the ones I read on the announcement. Thank Q 💙
Yvonne Smythe
Re: Sumif, index/match and iferror help
If I'm understanding correctly, you're trying to total "Untreated" where the date on the source sheet is the date on the current sheet row and the shift on the source sheet is "1st."
If that's accurate, I think you're complicating matters with the Index/Match. You can do what I'm describing using SUMIFS. Note the plural - so the difference between this and your SUMIF is essentially "the sum if this and if that and if the other and so on" multiple criteria are met, instead of looking for just one criterion.
=SUMIFS({Untreated}, {Date}, Date@row, {Shift}, "1st")
More on the SUMIFS function:
Good luck!
Kerry St. Thomas