Best Of
Re: What formula will pull client specific data from one sheet?
Lol, no worries. Your initial solution worked for me, so I used a combination of yours and his. You guys saved me so much time and effort.
Malcolm Jackson
Re: Conditional formatting multiple columns at once.
Hi,
I hope you're well and safe!
I agree, and in the meantime, here's a possible workaround. I'd recommend the fantastic add-on, which makes this possible (+ many other features).
SSFeatures from the brilliant Nathan. @SSFeatures
Would that work/help?
Also, Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment. Please share the link to the Idea here so that others and I can add our votes.
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD
✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏
Andrée Starå
Re: Working with Project Management Office
Will do, I have a "pro" developer appointment next week. I got on zoom earlier this week, and the rep was helpful, but I think was stumped by the root cause. We tried to re-write the formula using the data from the Project Intake Sheet, but I don't think that's right.. Personally I think there are sheets missing from the package, like the mystery "portfolio summary data".
I'm actually going to try and download it again, just for completeness sake.
I should ask since yours seems to work:
- when did you download your package?
- can you find the portfolio summary data, or can you open the reference in the formula?
Cheers,
Pete Spin
Re: Table view initial release is now generally available for all customers!
Thanks for the feedback, AHE! We agree. Improving performance is priority #1 for table teams. There's been some good progress recently and we're excited for a smoother and faster scroll experience to come to table very soon. Please keep the feedback coming!
tyson
Re: July Question of the Month - Join the conversation and receive a badge
My personal goal is to get healthier, too. I say too because I’ve noticed that many people here have set similar goals for themselves. So far, so good—and I hope that’s true for everyone. Wishing you all Godspeed in reaching your goals!
lav_bratis
Re: July Question of the Month - Join the conversation and receive a badge
One thing I had been working on over the past few years when I was working from home a lot more was running a 5K each month. I'd missed Jan & Feb a couple years in a row (for good reason, due to temperatures), but I caught it this year and have verbalized it at my staff meetings at work. My colleagues are able to hold me accountable (and are welcome to join in the festivities). I am 7 for 7 in 2025 for running a 5K each month with the goal to get 12 for 12 this calendar year.
Jake Gustafson
Re: Referencing an imported sheet
Happy to help!
I forgot about another solution.
I'd recommend the fantastic add-on, which makes this possible (+ many other features).
SSFeatures from the brilliant Nathan. @SSFeatures
Would that work/help?
✅ Remember! Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏
Andrée Starå
Re: Countifs Formula Referencing Another Sheet
Hi,
To add onto all the great information that Kelly provided, I used a "HAS" formula to ensure that all cells with "Active" were counted, even if another word was also in the same cell as opposed to counting cells that only had the word "Active" in them.
Also keep in mind that when you manually insert your Sheet reference, you should select the entire column by clicking the header, to ensure that all rows are captured as new data is entered...assuming you want the full column of data and not a small portion.
Range 1 should be the Division column, and Range 2 should be the Status column in your reference sheet.
=COUNTIFS({Certified Sheet Roster Range 1}, "Eastern", {Certified Sheet Roster Range 2}, HAS(@cell, "Active"))
Amanda Alv
Removing Shared Users
One thing that frustrates me the most is not being able to remove shared users easily.
I know in the User Management section I can type in a e-mail address and have that person removed from all shares.
However, I have 100+ shares. Why isn't there a list that shows me every person that is allowed to share on each sheet.
Currently, I cannot see a way to look at the entire account and see if we missed removing people from a sheet sharing if they have left the organization.
hcosta52671
Re: Formula to search across multiple contact column
Try adding a HAS to the MIN/COLLECT.
MIN(COLLECT({Initiative Plan | Start Date}, {Initiative Plan | Assigned To}, HAS(@cell, [Smartsheet Contact]@row)))
Paul Newcome