-
Datasources for Dropdown Menus
A sorely missing feature from Smartsheets right now is the ability to link dropdown menus to a central datasource - currently when designing sheets with dropdown menus, you need to manually update every sheet where the list exists making change management a pain. If we could populate those dropdown menus from a reference…
-
Selection Committee Ratings
Hello: We are going to have a selection committee of 4 that will be reviewing 5 candidates based on pre-established criteria. The selection committee will submit their reviews through a Smartsheet form (unless you think a different method is better). There will be a total of 20 reviews: 5 candidates x 4 reviewers in the…
-
Formulas in Dropdown column types
It would be nice if the dropdown list could be a formula instead of a hardcoded list. That way, I could use it to lookup an address based on a customer instead of having to manually enter it. This would be a good bandaid since SmartSheet looks like it will never implement Autofill cells.
-
How do I prevent the Workspace panel from opening automatically?
Starting today, the Workspace panel opens every time I refresh my reports, which is constantly. Is this a new "feature"? I save and refresh my reports dozens of times a day and am now wasting time closing the Workspace panel so it doesn't block columns from view. Is there a setting I can change so the panel only opens when…
-
How to share contacts in a published sheet?
I have contacts in my published sheet. I have it as Read Only - Full so the names can show and the emails if one hovers over it. But it doesn't allow external people to quickly copy the emails. Other than creating more columns to display the email, what other ways could I easily show the email address for others to copy,
-
Why is my percent complete not updating?
I have a project plan which pulls in data from a other referenced sheet. We track our development in a tracker, and have a dashboard and reports that help us understand where we are with progress for development. The percent complete pulls in automatically from a reference sheet into SubTasks in the project plan. However,…
-
How to quickly find a column by it's name in a sheet?
I have a very large sheet with many columns coming in from a form and many additional helper and result columns. I have created documentation of how it is working where I document the column named, its purpose and the formula used. (In addition to adding information to the column description). I am curious if there is a…
-
Update request not working
We are experiencing a significant issue with our Smartsheet used for audits. Currently, only three managers have direct access, while the remaining 26 team members submit their insights through an automated update request workflow. Recently, team members have encountered a persistent message stating, "Smartsheet has been…
-
Formula Help
I am trying to set up a metric sheet that pulls from helper columns on a sheet. The helper columns are set up to count values in a multivalued drop down list. I am want to use the date (specifically the month) and then for each column in my metric sheet I want to use the value above in the column to count items per month.…
-
Explore Seattle — Minority-Owned Business to check out while you’re at ENGAGE!
Hey there Community, Who’s attending ENGAGE? Whether it is your first time in Seattle or not, you might be on the lookout for nice spots to visit while you’re in the area. We’ve got you! At Smartsheet, we run on the belief that we can empower anyone to drive meaningful change, and that changing the way the world works…