Best Of
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
Re: Registration is open! Come be in community at ENGAGE 2025
I just got approved to attend this year. So excited!
Isis Taylor
Re: Smartsheet Contact Support is Broken in macOS
Let me see if someone else can test on our side before I escalate to IT Support
mikedvzo
Re: Generate Documents with Adobe Sign
Would love the addition of Adobe Sign to integrate with Smartsheet alongside with DocuSign. Hopefully we get the ball rolling on this as soon as possible!
Tummi
Re: Generate Documents with Adobe Sign
A vote for AdobeSign integration. Please and thank you!
trey.wainwright