Best Of
Re: Automatically Sort Rows in Sheets
I would love to see an option in the Automations to trigger a Sort on changes or row adds.
slarijani
Re: Need help with a formula that pulls from two sheets but gives #INVALID REF for one sheet
Try highlighting the whole {cross sheet reference} including the curly brackets on either side and then hit the backspace button on your keyboard.
Paul Newcome
Re: Bi-directional sync for linked cells
is there a product feature request I can upvote?
seems like this is a feature that's been talked about since 2015:
Harry Luk
Smartsheet needs an "Are you sure you want to cancel?" prompt or auto-save for workflows
Recommendation: Please implement a prompt after a user hits the "Cancel" button in the workflows, to ask the user if they are sure they want to cancel and lose their data. Alternatively, an auto-save feature would help users not lose their data when building workflows.
I had built a work flow that included 25+ condition paths, Update Requests to specific users with custom messages for each path, and actions for each path. The workflow was 99% complete and just needed a minor edit to {{brackets}} referenced in the Update Request action under each conditional path.
I'm working on a laptop and accidentally clicked the "Cancel" button. I lost all of the work from the past hour+. Having a prompt or auto-save would have given me an opportunity to not lose the work built.
ashleyh24
Re: File Attachment to Multiple Rows in a Sheet
We would love this feature. We are frequently needing to attach items to multiple rows and there is no consistency between users. Sometimes it gets added to one row but other times to multiple.
Jennifer C
Conditional Formatting Font color change
Hello,
Is there a way to change the font color of a single items in a dropdown list on the specific column only and not apply the font color change to the entire row?
Thank you!
TaliN
TaliRXM
Make Dates Connected to Resource Management Editable via Update Requests
I have recently learned via Smartsheet support that when date fields within a sheet are connected to Resource Management, that the Update Request automation will not allow users to update these date fields. We use RM for very high level resource loading across various functions within the org, with one of these items contributing to this being our strategic roadmap, that not all employees have visibility into. I would like for individuals to still be able to update the timeframe associated with their initiatives, without having to create helper columns and creating a manual aspect of upkeep.
sara.larson.cws
Content and Chat Controls
it is very odd that only by enabling upload from computer, the bulk import of users is avail.
Our company needs to ensure any documents attached to Smartsheet are saved on SharePoint only, not the device.
Having those two functionalities combined by the current setup is very unhelpful.
Can you pls look into changing this?
Helena P.
Re: Return multiple values from one search criteria
@PeggyLang Yes. You would need the "Number" helper column that is pre-filled with the numbers 1 through however many you think you will need. Then you would use an INDEX/DISTINCT/COLLECT combo to get the stores
=IFERROR(INDEX(DISTINCT(COLLECT({Source Sheet Store # Column}, {Source Sheet City Column}, @cell = "City Name")), Number@row), "")
Then you would use a standard INDEX/MATCH to pull over the rest of the data based on the store number.
=IFERROR(INDEX({Source Sheet Address Column}, MATCH([Store #]@row, {Source Sheet Store # Column}, 0)), "")
Paul Newcome
Re: Countifs Date range clash formula with Distinct value criteria
Okay I think I have the answer, it's
=COUNTIFS(Start:Start, Start@row >= @cell, Finish:Finish, Finish@row <= @cell, 👤:👤, HAS(@cell, 👤@row))
Sam Swain
