-
Yielding blank cells
Hello, I'm using health circles to indicate progress. However, I want the circles (green, red, yellow, and gray) to show active stages in the process (complete, incomplete, in progress, on hold, respectively). I want phases that are not yet started, because the start date has not yet started or is not yet set, to remain…
-
Can I hide rows using a condition?
Hello, Is there a way for me to hide rows if one of the cells says "completed" by using a conditioning format? If that is not possible, is there a formula that I can implement that would get the job done? I am managing a photography team and they have expressed the concern of seeing too much on their sheets that would…
-
Collaborators can't sort rows
I've been using Smartsheet for years, and this is the first time I've encountered this issue. I have a number of free collaborators in a shared space, all having access to 6 sheets. They all have the same permission level: Editor - Can Share. At first it was working fine, but then people started emailing me saying they…
-
Updating Date Column if Another Column has been Changed
I am trying to create a formula to change a Date column to update to the current date when another column has been changed. I have used the TODAY function within IF but this updates the current date every time the sheet is opened and saved. I only want the Date cell to change when a specific other cell is changed.…
-
SUMIFS to Calculate Values for a Specific Year/Date Range
I am trying to use SUMIFS with multiple criteria, and I am failing horribly. I seem to be having trouble when I try to add the criterion to sum data from a specific year (from a Date field) and/or when I attempt to add data from a date range. I have searched the community questions, and I haven't been successful in finding…
-
Combining Two Sheets into a Report
I have two task lists with slightly different columns, but there are some overlap - like status, completion date, & targeted completion date. I would like to run a report or some how combine all the tasks into one report/view/sheet - while continuing to maintain the two task list as separate sheets. I tried to create a…
-
Disable sorting for users, but still allow data entry
We are having a problem where accidental sorting occurs on a sheet used by several users, and I am looking to only allow users to enter data into a cell, but protect the placement of columns and rows. In my research I can not see a way to do this, because it is my understanding that if a row is locked, no data can be…
-
How best to link 3 columns from a mastersheet to a secondary sheet.
Hello, I've had a colleague come to me with a query about how best to link 2 sheets. Her enquiry includes a handy diagram: I'm wondering if cell linking would be best bet here? I realise this would obviously require her to keep having to action this for the 3 columns in question, when a new row of data is entered but it…
-
Is it possible to update a sheet by importing a new version of it.
Hi, Is it possible to update the information of a Sheet by replacing it with a new version of the sheet. In our current process, we have daily approvals, however by using an approval request or an update request, requires a lot of effort from the status owner e.g: 1.-Status owner receives "x" number of update/Approval…
-
Parent Row % Complete Doesn't make any sense
See attached image The Parent Row shows 7% complete based on the 1 item being 100% and all other items being in the future. The target % complete shows 20% which makes no sense to me. There is a formula for Target % complete: =IFERROR(IF(Status@row <> "Completed", IF(NETDAYS([Today (hidden)]$1, [Planned End]@row) /…
