Best Of
Re: Hidden Columns List
I love this suggestion and have suggested it to Smartsheet for years! To expand on it further, I would love for there to not only be a multi-select option for columns that are hidden, but one that allows a selection of which columns to print/export. The print functionality hasn't improved in years. I understand that this is meant to be an online collaboration tool and don't expect significant print export functionality, but we often need to export data in a physical form and don't want to have to create a separate report every time we need to "hide" columns just to print/export.
Joe C.
Re: Forms - link a document
Hi,
I hope you're well and safe!
Select the text, click here, and then paste the link to the Smartsheet asset.
Make sense? Did it work/help?
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/help to answer! I appreciate it, thank you! 🙏
Andrée Starå
Re: Introducing the Smartsheet Unlocked podcast...
Love the idea and episode! You're passion for Smartsheet is contagious! And so is Willl's!
Tim C
Re: Introducing the Smartsheet Unlocked podcast...
Gotta give a special call out for just how good the editing is in this first episode.
Love how you do things like showing the Smartsheet User Groups page right as you an Will start talking about user groups. It'll make it way easier for people who are new to Smartsheet to be able to follow along with the podcast! Same thing with the Overachievers page.
SSFeatures
Re: How do I update a status based on 3 different approvals.
hi @HRR
try this:
=IF(AND([Approver 1]@row = "Approved", [Approver 2]@row = "Approved", [Approver 3]@row = "Approved"),"Approved", "Not Approved")
shall work now.
kowal
Re: Created Date Column Background behaviour
Try getting rid of the TIME function and just keeping the RIGHT function.
Paul Newcome
Re: COUNTIFS between dates & criteria.
@veidelis Try this:
=COUNTIFS({Range}, IFERROR(YEAR(@cell), 0) = 2024)
Paul Newcome
Re: Is there a way to have dynamic cell updates? My previous attempts were unsuccessful.
If you are able to set up data shuttles, you can use an offload data shuttle to save an excel file as attachment to your sheet and you can set up an upload shuttle (running on attachments) to update the dropdown on a selected sheet and column.
If that could help you let me know and I could help you set it up.
Edit: If you mean by Regular Smartsheet, no data shuttles, I don't know if this is possible.
Jesse G.
Re: Cross sheet references not updating
Thank you all for your patience.
Engineering is actively working on resolving issues with cross-sheet formulas not updating unless the sheet is opened. A fix is expected to be available by Tuesday.
Hope this helps!
Cheers,
Isaac.
Isaac A.
Re: Can Smartsheet display five health color indicators?
Happy to help!
You can also use them in formulas by surrounding the emojis with "🔵", similar to how you use text in a formula.
Make sense?
✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!
Andrée Starå