-
Why is my progress not being completed?
Hi everyone! I am having trouble advancing in my course because for some reason I have 2 modules that do not mark as "complete", could someone help me out with this?
-
Workflow Automation not working - change Status field to Complete
I'm using a sheet for a project plan. I have a % Complete column and a manual dropdown column for Status (options are Not Started, In Progress, Completed, At Risk, etc.). I want to change the Status column to "Complete" when the % Complete for a task is changed to 100%. Screenshot of my automation set-up is below. Can…
-
Which function in Smartsheet can be used as an equivalent to the “Scroll to Task” feature in Microsoft Project?
Hi, I have a large project plan, and sometimes I get lost among all the information when trying to locate specific tasks in the Gantt chart. Does Smartsheet have a feature similar to Microsoft Project that allows you to quickly scroll to or find a task?
-
is there a way to have more colors available in sheets as in dashboards?
hi, When customizing dashboards, I notice that there are more options available to choose or create color combinations compared to the static color palette that appears in sheets. Do you know how I can include more colors in sheets, similar to what is available in dashboards?
-
Workspace
I have a workspace titled 2026 Activity. I need to create another one for 2027 Activity. All the sheets in the 2026 workspace will be moved to the 2027 workspace including the dashboard. All data must be retained in the 2026 workspace but deleted from the 2027 workspace. How can I make this happen?
-
Deployment roadmap
We have multiple projects for 150+ countries and we want to create a heatmap style grid to track which project is live in which country. Ideally, we want to convert this grid into a timeline, what would be the ideal way to create this smartsheet?
-
Expand Font Options in Smartsheet to Support Modern Branding, Accessibility & Readability
I use Smartsheet daily for project tracking, documentation, and cross-functional communication. One of the biggest limitations I run into is the very small set of available fonts within grid sheets. Across organizations around the world, teams have moved away from legacy fonts like Arial and Times in favor of modern,…
-
Additional Criteria changes result
Hi folks, I'm struggling with a formula that should be simple. When the formula is this, it works great for one of two Types. The second type pulls the wrong Billing Annual Fee. =IFERROR(INDEX(COLLECT({Billing Annual Fee}, {Segment}, Segment@row, {Billing Ownership}, [Billing Ownership]@row), 1), 0) When I modify the…
-
Legacy Dropdown Functionality Option
Good afternoon, Recently there was a change that made searching a dropdown by typing inside of it switch from an exact match method where typing S would only show entries that begin with S to a search within method where typing S would show all results with the letter S in them. I can see how this would be beneficial in…
-
Decimals added in drop down value from form
Hi, I have a column that can only be a drop down value. Unfortunately this value, project numbers, has a mix of both decimal and non-decimal values. For example, project 356 could be the main project, but has ancillary projects: 356.1, 356.2, ect. What I'm seeing is that in my project ID column Smartsheet has started…