-
Can I apply conditional formatting to a Workspace?
I have over 30 sheets (and growing daily), in a workspace. What is the quickest way to apply the same conditional formatting to every sheet?
-
COUNTIFS & #INVALID REF Error
Hi! I built a rollup sheet with the following formulas. They work, but when a row is deleted (probably added too), the formula on the reference sheet the rollup sheet causes the #INVALID REF error. I have to manually edit the formula to get it to work again. One section has about 50 rows and 3 columns of formulas.…
-
Can i reference a workspace in smartsheet formulas
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, what would be the formula?
-
Non-working day shading in Gantt not consistent
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 no formatting and some have the grey/white formatting. Why do some have it and others do not. I cannot find a setting for…
-
Form Submission to Rollup
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 according to a rollup and sort. For example: the form asks for pencil color, length and quantity I enter Green, 127mm and 3 I…
-
Inventory Management
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 automatically remove the inventory items from each line in the Sold column. Example: Customer #1 bought 5 items of my Stock #2.…
-
Sending Email Group a form
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 respond to the survey and I will have 10 rows of responses. Currently, if I send the form to 2 or more users the first persons…
-
Can I get a notification when a new collaborator has been added to a sheet?
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 collaborator across all the multiple sheets so I can add these users in their specific groups (which grant them access to view…
-
Custom form fields not coming over after form is submitted
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, the standard fields are being displayed and not my custom fields so I am not able to see the information being collected in…
-
Users getting kicked off Smartsheet
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 they finish. Is there a reason for this? What could it be? Since it's intermittent and not everyone, I really don't know what…
