Best Of
Re: Count Multiple Values in the Same Column
Hello @Almrie217
You're almost there! You're just missing some formula logic on your OR statement using "@cell".
Try this:
=COUNTIFS([PRODUCTION STAGE]:[PRODUCTION STAGE],OR(@cell="DELIVERED",@cell="PRODUCTION"),TYPE:TYPE,OR(@cell="Mug",@cell="Cup"))
If you'll be using a multi-select dropdown column, you need to utilize the HAS function.
=COUNTIFS([PRODUCTION STAGE]:[PRODUCTION STAGE],OR(@cell="DELIVERED",@cell="PRODUCTION"),TYPE:TYPE,OR(HAS(@cell,"Mug"),HAS(@cell,"Cup")))
Note that the HAS function checks if the cell has that value selected. So for example, you have 3 rows that has either "Mug", "Cup", or both "Mug" and "Cup" in a cell. It will not count as 2 values when a cell contains both Mug and Cup. I hope I makes sense.
Melissa Yamada
Re: Display hours in a day on gantt and agenda view
My team had an idea to start logging machine times. We have a machine that scans things and we wanted a cleaner way to start scheduling people to use it.
Essentially people would go to the sheet, log the time they would be using it (name, scan reason, how long scan takes - scan time would essentially be log time) so people would know at this specific time the machine is being used. Logs would be in Hours/Minutes not days/weeks.
Project Management template would be perfect for this but it only does days/weeks. The calendar would be huge for this if it allowed for hours/minutes
Don't know if smartsheet currently supports this but I can't find a way around it
santiago.rendon
Sheet opening with filter but there's no default filter
Why is a Smartsheet opening with a specific filter on? Whenever I open a specific Smartsheet, it opens with this one specific filter on, even if I save it with no filter on. This also happens if I click the link in a notification email. I've checked to see if it was set up as the default, but the Default View is set to Filter = None. I've deleted the filter and created a new one and this still happens. It's also the last filter created on this sheet, although I was not the original creator. I've also cleared my cache, because this is not happening to my co-worker.
clair11
Re: Is there a way to turn off automatically applying the last filter used when reloading a Smartsheet?
This is something that my team has just started experiencing. It is defaulting to the last filter they used rather than to the default for the sheet (in this case, no filter). Is there a way we can "turn off" the last filter they used?
meghan.hale66546
Re: How far back does the "View Cell History" track?
Hi @idefreitas
I hope you're well and safe!
Both the Cell History and Activity Log are unlimited, as far as I know.
The 90 days limit on Activity Log is when you export it.
Would that work/help?
I hope that helps!
Be safe and have a fantastic weekend!
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å
PROPER Function
Hi!
I wanted to submit a feature request to add to Smartsheet. I organize a lot of documents that are displayed in all caps [Ex. PLEASE SUBMIT ADDITIONAL NEEDED DOCUMENTS]. I have noticed there is not an action/formula available that changes the text to PROPER like in excel [Ex. Please Submit Additional Needed Documents]. I believe this would be a great function to include/add!
GeorgiaM.
Re: Community Corner Newsletter [March 2025]
When I come to Costa Rica, can I get some grilled shrimp by Chef Isaac? 🍤👨🍳
Alison C.
Re: Symbol Flexibility - more symbol colors/options
Better yet, allow users to add themselves.
Dom Angom
Re: HYPERLINK Function
When a cell is bringing data from another cell using a formula, it can only show the text, but the hyperlink of the other cell is not clickable in this cell. Looking fwd to be able to click the hyperlink in the formula cell as well.
benzion123_