Sheets
Discussion List
- I am attempting to parse a large amount of sheets together and have hit a snag in a formula. My data looks like below: H | A | B | C 1 | 7 | 4 | 9 0 | 2 | 1 | 5 1 | 5 | 3 | 1 H is a helper column disp…
- Hi all I'm trying to create a status report which would roll up project tasks and their progress into an easily view-able report and/or widget The data will be across multiple sheets and I'm trying to…
- 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…
- 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 t…
- 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 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 referenci…
- 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 th…
- 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 (…
- 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
- 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…
