-
Merged: Automation enhancement - allow for the ability to copy data from one column to another colu…
This discussion has been merged.
-
View all global updates created by other program leads
I would like to be able to view all global updates created for our program, regardless of which program lead created the update. We are sharing workload and so need to be able to see what each other has done and be able to check each other's run logs for errors.
-
Automation trigger question
I'll try to describe the issue as best I can: I have a notification automation that is triggered by a row change (an attachment is added). The automation must also meet two conditions, both of which are checkboxes that must be checked to satisfy the two conditions. The first of these checkboxes triggers an earlier…
-
Gantt charts and Dashboards
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…
-
Extract Cell History For Formulas
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…
-
Looking to compare two dates to create an Integer value across sheets
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…
-
NEW! Reorder Work Insights in full-screen and right-panel modes!
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…
-
Lock/Unlock a COLUMN when criteria are met
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.
-
SUM of Hours column
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…
-
Product Development Inflight Project Dashboard
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…