I'd like to be able to link to fields in a separate worksheet based on certain criteria. I'll give an example to try and explain: I have multiple projects running concurrently; each has a separate pro…
Is this possible? I went to try and create a metrics sheet from the report but it doesn't show up. Building the report was supposed to group all of my similar items together, why can i not then build …
I'm new to SS. This is my first project. I have an audit process I am building for a customer. There are 5 separate forms needed for the audit process. I originally had all 5 forms feeding the same sh…
We are trying to rollup multiple project sheets that have tied in metrics. The gantt view is not allowing us to have the dependency arrows on our rollup. Do you have any suggestions how to create this…
My Sheet contains all linked cells. There are 4 rows. I create a report to pull everything from the sheet with no conditions (Who? What? When?) but I only get back 3 rows. I have tried adding addition…
Hello, I'm trying to setup a "Line Quantity" of children where the primary column contains a 5 digit number. These numbers indicate line items of a purchase order and have a hierarchy themselves. The…
Hi Smart Sheet Community! I am applying a formula to a cell in our project schedule sheets that I found in a couple posts to grab the MAX value of the Modified (Date) column: =MAX(Modified:Modified) +…
Hi all, I have currently set up cell linking, however I only want it to cell link once the drop down box has been changed to 'Converted'. As in, we receive a lead and add the data to that lead. Once t…