-
50+ Multi Select Formula + Workflow Suggestions
Hello! We are needing suggestions on how to better setup / populate estimated costs in our current workflow below. We are also open to rebuilding the two sheets and overall workflow as well. Currently we have the workflow setup as follows - Sheet 1 - Column 1 = "Request Set NAME", Column 2 = "Price" *Note - there are…
-
Using Smartsheet for SOP / policy acknowledgements?
I’m exploring using Smartsheet as a central place to manage SOPs and internal documents and was curious if anyone is actively using it this way. Specifically, I’m interested in how people are handling things like: Notifying staff when a new SOP or document is posted or updated Requiring staff to acknowledge they’ve read it…
-
Portfolio‑Level Gantt View Enhancement to Display Multiple Milestones per Project Row
I would like to confirm whether the system supports rendering multiple date fields (approximately 5–6 date columns) from a dataset within a single row in the Gantt or Timeline visualisation. The requirement is to display several milestone dates—such as multiple Gate Review events—on the same horizontal timeline for each…
-
Count % Completion of Checked Items by Each Sub Project
Good morning Smartsheet Community, I am trying to put together a grid that captures the percentages complete broken down by individual areas of a project. Below are the variables I am trying to capture Percentages To Capture Power Installation % Data Installation % Millwork Completion % Configuration % Installation %…
-
Regaining Access to Data After Having to Reinstate Smartsheet Subscription
I do not use Smartsheet but am the admin for a company that uses it daily. We had a former employee cancel our company plan when the annual invoice inadvertently charged his credit card. We have since reinstated the plan; however, my colleagues are unable to access, edit, view or otherwise do anything with their data and…
-
support multiple milestone dates within a single row in Gantt View
Currently, Smartsheet allows only one Start Date and one End Date to generate a Gantt bar or milestone. However, many projects involve several key milestone dates such as approval dates, review checkpoints, testing completion, and launch readiness. These milestones are often stored in separate columns within the same row,…
-
Custom Column View Templates
Is it possible to save custom views for columns? I would like to be able to show, hide, sort, and order columns via a template. I am able to filter based on specific conditions but I also need to be able to view the data a specific way.
-
When will the drop-down properties include 'Values from Another Sheet'
I understand that in the non-Government version of Smartsheet, there is an option to populate a drop-down list column with values pulled from another sheet. Does anyone know if/when this feature will be available in the .gov (Government) version of Smartsheet? If so, will the drop-down list dynamically update as the source…
-
Is there a way to save and recall sheet layout (i.e. column visibility, order, width, etc.)
I provide updates to different groups in PDF and Excel format. Not all columns are visible to all groups, and they aren't always in the same order for all groups. I'm wasting more time than I would like unhiding and re-hiding specific columns, dragging the columns into the right order, and then setting the column widths,…
-
Time Elapsed to Today in Months/Years
Hi! I'm trying to figure out how to use the NETDAYS formula to show how long someone has been a member of a certain team. I can't get it to measure to today using the formula that the website suggests. I want it to be running so that whenever I log on I can see the time elapsed to the day I'm looking at the sheet. Can…