I am currently referencing 3 ranges off a sheet as per attachment. I have a workspace which has many sheets with the same structure. Can I reference the workspace to pick up all the same data? If so, …
When I select Gantt view some of my child tasks have work day and non-work day shading. Non-workdays are light grey and work days are White. This occurs randomly on the sheet. Several child rows have …
I've been thinking about this for a while.. I would like to take the laggy and awkward pivot middle-man out of the process. I think there should be an option for sheet with a form to add the new row a…
I'm trying to find a way to remove inventory when an order is sold, other than manually changing the numbers. I have a form set up to add new orders to the bottom of the sheet. I need a formula to aut…
I am wondering if there is a way to email a survey form to my group and when they each respond individually their responses fill in 1 row at a time. Example: I have 10 people in my group, they each re…
Hello, I have multiple sheets and dashboards created for different departments. We are allowing editors the ability to add collaborators to their sheets. I need to track who has been added as a new co…
Hello, I have created custom fields on a form. The url provided to fill out the form has the correct custom fields displayed. I complete the form and submit. When the form comes into my Smartsheet, th…
Hello, I created a Smartsheet that tracks a form completion. The problem is that some users (different users on different computers and on different days) are getting kicked out of the Form before the…
Hello, We are referencing another sheet and are wanting to know how many times the word "SNAP" appears in the multi-select cells within a row. Right now, this is what we have, but it won't work. We ha…
This happens on 2 of my 10 sheets, and only started happening a few weeks ago. The moment I mouse over the grid of my sheet, the disk save icon immediately goes blue (enabled), thus indicating that so…