-
Is the Parent Row expanded?
Is there a way to know if a parent row is expanded (that is the + sign was clicked and the children are visible)? For example, my sheet contains 3 rows that are parents (Orders 1, 2, and 3 below) each representing a different order. The children of each parent is an item in that order. For sake of discussion and…
-
Scrolling with a mouse wheel
This is a minor thing but trying to figure out how to scroll up and down in my sheets using the wheel on my mouse. This works in every other piece of software I use but in a Smartsheet I have to use the slider bar on the side to move up and down through a sheet.
-
Automation Using Dates to Generate Reminders
Hi Everyone, New to Smartsheet so sorry for the rudimentary question. I'm having trouble getting automation to do what I want it to. I have a project sheet with multiple tasks with various due dates. I'm trying to send reminders prior to the due date. I do the following: Trigger: Run Once: On: Date Field: Due Date: 9:00AM…
-
Referencing a Column in Another Sheet
I am having trouble referencing a Column in another sheet through an IF formula I am trying to do. My current formulas is =IF({Sheet 1 Range 1} = 1, {Sheet 2 Range 2}). The first Column I am referencing is a Checkbox Column, and I only want it to return the value in Range 2 unless Range 1 is Checked. Whenever I do this…
-
Count if formulas
Hello, I have a fairly simple formula that I need assistance with. I have a 'Date completed' column (UK Date format) and a check box column, 'Test1'. I want to do a count in a separate cell for all the rows that have check boxes ticked for within specified month period. E.g. Count the number of test completed in May. I…
-
Summing VLOOKUP results
Hey community, I'm creating a way to judge submissions, where each judge has their own smartsheet (so they can see/edit their own markings but not be influenced by others). I need to be able to know (1) how many times a submission was judged, and (2) what the total score is on one single sheet. * Currently I've drafted the…
-
Preventing a formula overwrite?
Looking to prevent anyone from overwriting a column that has a formula. This is currently not possible, correct? Owners and admins can always overwrite a cell's formula? Thanks, AEG
-
COUNTIFS problems
I am doing a metrics sheet to give department heads better visibility on our workflow. One of the metrics I need is how many items have been shipped, but not yet invoiced, I have a date shipped culumn (date) and an invoiced check box (boolean). Several other formulas have similar setup criteria and are also not working.…
-
Workspaces do not appear on "link to" file list
In taking the eAcademy course, in the Cell Linking chapter, I am told to link to a file in the eAcademy workspace. When I try to do that, I notice that I have no access to any workspaces from the link to functionality. I can get my learning about this concept from the class. My concern is, moving forward, will I not have…
-
Dropdown List Multiselect Feature Request
I would like to submit a Smartsheet feature request that will allow users to do a "Multiselect" for a Column type of "Dropdown list". At the moment the only way I can do something similar is to create multiple checkbox columns, which makes the sheet hard to use due to all the extra columns. In Smartsheet today, you can…