-
Formula to calculate task completion by owner by referencing parent rows
Hello all, I am looking for some help with a formula. I'm super close to getting it but can't figure out the last piece. Goal: I have a sheet tracking task completion and want to calculate, month by month, the percentage of tasks completed for each person. Setup: Level 1 rows = person’s name (owner of tasks) Level 2 rows =…
-
Automatic Workflow Question
I am trying to copy the data from a Business Problem cell to a Project Description cell without impacting/changing previous entries. Is it possible to create a single automation workflow that copies/replicates data from "Business Problem" into "Project Description" in the same worksheet? I tried the column formula route…
-
Why are we unable to resize anything within the Browse menu?
The Browse menu is really unwieldy and as someone who loves to have side by side windows, so much of this space is wasted because the menu is both unconfigurably and unresizeable. Is there anything we can do about this? I would love to be able to just close the "Workspace Shared To" menu (the share button is literally…
-
Disable auto update of start dates for dependent tasks
Looks like there was a thread on this https://community.smartsheet.com/discussion/7262/forced-dates-when-dependency-is-enabled to disable auto-update of start dates when using the predecessor feature.. is this implemented?
-
Protect Integration-Critical Columns and Rows While Still Letting Admins Add Content
In our organization, Smartsheet sheets are more than collaborative tools — they act as data sources for integrated applications, dashboards, and automation workflows. These integrations rely on specific columns, rows, and cell references remaining consistent over time. However, users with Admin rights can currently rename,…
-
Drag and Drop in Timeline view
It would be great if I could move the boxes around in Timeline view by dragging and dropping. Currently the only way to move them is to edit the dates in either the box details or the grid itself.
-
Issue with unable to save a project template in the same folder
Hello Community, I am having a challenge in saving a project template in the same folder, when I am trying it to save as new it gets saved in the sheets and not in the same folder, even when I am trying to set the location it doesn't show options and also doesn't give any list when trying to browse, can any one help me.
-
Why does the date default to 2025
I'm working on a Smartsheet for items that are in 2026 and I have some columns that are set to the date field formatted like 15-May-26. The issue is that when I enter the date like 15 May, normally I can hit enter and it would enter the year, but for some reason, it is still set on defaulting to 2025 as the year. Of course…
-
NEW PM Porfolio Template questions
In the Project List, I would like to link a project update cell located in each Project Plan to a cell in the Project List. The project list only gives me the option to link a column. How can i link data to come into the Project List? I can link data out.. When I attempt to link by column, the target column in the project…
-
basic formula im sure, but Im new to this
I am trying to write a formula that says the if the end date is before today that it selects the "Late" option out of the drop down in Status. I got most of the way there but keep getting an error. HELP