Best Of
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å
Re: Blank rows added to bottom of sheet / form
Hi @MeghanRyan
I hope you're well and safe!
Unfortunately, it's not possible to remove them, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Andrée Starå
Re: Can Smartsheet display five health color indicators?
You can add them to the drop-down column option.
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å
Re: Sort by Date column within the Report - Report pulls in parent and child/ancestor rows
@SSFeatures This report brings in multiple different sheets from various project folders within a workspace as they are created. Ideally, we keep the parent row in as part of the report. Thanks for your feedback!
mmac