-
Cut not working
Starting 7/30/18 we noticed that using either the keyboard shortcut or the right-click option to cut a line within a SmartSheet would sometimes leave behind the original line (acting more like copy than cut) when moving to a different place in the SmartSheet. Two people within our organization have recreated the problem.…
-
Formula in a date column
I am trying to use the vlookup formula into the scheduled date column that also has dependency on predecessors. When inserting the formula into that column, the formula does not override that dependency. Is there a workaround to this?
-
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…
