It would be great if we could have a 'Hidden' checkbox attribute added to the Column definition in Sheets (with Name, Column Type, etc.). In many cases when we have Sheets with multiple helper columns that we would rather be hidden, I find that it is a time-consuming task to re-select the same columns to hide again after…
Automation option that will list the cell history in a similar format that is available with the cell view history.
The ability to copy an existing sheet summary field and edit to save with modified formula.
Howdy! I am new to smart sheet, and have the programming knowledge of a 1st grader :-) I am attempting to write a formula that returns a specified value IF it finds ANY of the specified values in a cell (that's within the same row). I also want to know if the cell is NULL or if ANY of the values are NOT found. For example:…
I'm challenge by this situation and the only way I have worked out how to do it is to use the mouse to click into another cell. What happens is, after I have made a selection of one or more options from a drop-down list, the following keyboard commands result in undesirable effects: Tab or Enter while mouse is hovering…
Hello, thank you for taking the time to look at this and I appreciate any assistance anyone out there might be able to supply. I'm trying create a Rolling 12 Month Formula and running into an issue getting it to work. I have multiple programs on a sheet that have metrics and are nested under a blue header row. The data…
I have an if statement referencing another column named "Country" - I want to define this if statement into a Column Formula but it says "the column formula syntax isn't quite right". This is my IF statement. =IF(Country1 = "US", "01-440-0187 (US)", IF(Country1 = "Canada", "01-440-0188 (CA)", IF(Country1 = "Mexico",…
Is there any way to track forms that have been started, but not submitted?
Hi all! I am trying to determine what formula to use when calculating Harvey Balls using two different column details. Harvey Balls are in the "Corrective Action" column. What I want to do: Harvey Ball to be Full when all children rows are checked in "done" column AND there is text in the "Response" column Harvey ball to…
It would be nice to be able to see what sheet the row came from rather than just that it was moved from another sheet.