-
Multi-Project Gantt Chart with 1 Swimlane Per Project
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
-
Flagging Tasks as 'Blocked' if Predecessors are past due
Hi everyone! New to Smartsheet and trying to build some features for my company. I've been doing a lot of reading and tutorials, and I think I'm close to the end of this problem. Like the title says, if a task goes past its due date, I would all of its dependents tasks to flip to 'Blocked' status. I made it so far as to…
-
Auto Number column will not reset
I need to reset my auto number schema to a different format. However, when I do, all new rows still use the old format and continue with the same numbering. I have tried deleting the column, saving and recreating but it does not work. I have also tried the web version and desktop app and get the same results. I have…
-
Recover file
Hi, I want to revover an file that i delete by mistake. How can I recover it?
-
Owner of the sheets but only have Viewer access right
I have subscripted Pro user plan and currently work on 3 sheets. Two of the sheets suddenly not allow me to EDIT and I can see I only a Viewer of the sheet, but actually I am the only member of the plan. Really don't know how to fix the access right to be admin of those sheets.
-
Not able to allow/update permission for my members to access smartsheet
My colleague had a viewer access. Then updated the access to editor-can share. But the access not updated. The account doesnt change to provisional member its still viewer. Anyone else facing this issue ?
-
Cell values automatically reverting to previous values. Changes won't save.
I have a very serious concern. I am updating the contacts column to change the contact from Richard to Teresa. However, after about 10-15 minutes Smartsheet automatically reverts to the original contact. This has been happening for a week . I am very concerned because how can I be assured that changes are saved in all my…
-
Automation change cell value no longer being translated to a $$ value?
Hi, I've noticed this issue in two of my smartsheet processes. I have an automation set up as follows: "When rows are added are changed and [Column A] changes to [Any Value], change cell value in [Column B] to "60" " I then set column B to be $ currency format. Up until recently, "60" changed to "$60.00" without issue but…
-
Feature request: How to merge cells in Smartsheet
merge data into cells like excel does in a user friendly way similar to this article. https://www.projectwidgets.com/how-to-merge-cells-in-smartsheet/
-
Best way to visually separate different phases in a Smartsheet tracker?
Hi, I often build trackers for workstreams that move through a process or lifecycle. Where these involve distinct phases, I’d like a clearer way to visually separate each phase within the sheet. At the moment, I’m just using coloured columns/lines as section breaks, but it doesn’t feel particularly clean or optimised. Does…