Hi. new here to the forum; recently created a Smartsheet Gantt chart and subsequently integrated it into a Smartsheet Dashboard. Looks great except --- I seem to have lost my indentation of my subtasks under a parent task, and that makes reading the results a lot more difficult. The other thing that I'd love to do is to be…
Hello, Is there any way to extract the Cell history to calculate formulas. What I am trying to do is create metrics off the dates in the cell history. I.E. if a Dropdown list column starts on July 1 with Value 1 and changes to Value 2 on December 10th then Value 3 on December 21st. I want to measure and tract the time…
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
Hello, I am looking to create a tracker that tells me the quantity of samples that arrived in the estimated time against the actual time. My thought process was you have two date columns Date Column A (estimated date) and Date Column B (actual date). I would in my raw data sheet create a link to Column B first than compare…
Hi Community! We’re excited to announce that you can now reorder Work Insights in full-screen and right-panel modes! This release allows you to tell more of a story with your Work Insights, or to optimize their order to best fit your needs. We hope this update saves you time and gives your Work Insights that much more…
I have a sheet in which there are about a dozen columns. Looking for one of the columns (for each row) to be locked until certain criteria are met in a different column of that row.
Hello, I have four columns: Task | Hours | Assigned to | Total hours The 'hours' column is how much time (hours) it will take to do the task, the 'assigned to' you can assign the task for more than one person. Now I need the 'total hours' column to show me how much time it will take for a task (example: Task1 takes 1 hour…
I feel like I've looked at all of the templates and am still stumped on which one I would use to display a 2023 - 2024 project dashboard. Currently my boss put it in a Excel but not in a way that you can sort. I want to be able to use Smartsheets to input all potential product launches under each of the categories. Below…
It would be very useful to be able to clone a Salesforce Connector workflow and then make changes as needed. This would save a ton of time when you are mapping mostly the same fields on intake sheets that have already been cloned in Smartsheet.
In a world that looks at automations and limit human intervention to reduce risk and resources, the standardization of how data is imported and exported through Data Shuttle is inconsistent forcing human intervention as a work around. It would be helpful if the export/offload of multi select fields through Data Shuttle can…