-
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…
-
Lookup/CountIF Formulas for Multi-Select ranges
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 have tried multiple different formulas as well and cannot seem to find anything to count the number of time "SNAP" shows up in…
-
Divide by Zero Message and IFERROR formula
I am getting a Divide by Zero Message when putting in this formula. It is correct because there are no items that fit this criteria to average. =AVG(COLLECT({Credit Granting Article Tracker Compliance}, {Credit Granting Article Tracker Month Completed}, "2", {Credit Granting Article Tracker Major?}, "No")) I attempted to…
-
SUM of Check Box IF Function that returns a value.
I've created several "IF" formulas on a sheet. An example of one is as follows: =IF([Kickplate Installation]1, "$42.86", ""). When the checkbox is checked, it does return my value of $42.86. However, I've also created a column to total all of the values returned. When I "Sum" the returned values from the formula, the "SUM"…
-
Combining cells from one sheet into a single cell on another sheet
I have a master spreadsheet with many columns (sheet1). From that, I want to create a second sheet with fewer columns (sheet2). The first column in sheet1 is 3 cells combined (=[Column1]1 + "-" + [Column2]1 + "-" + [Column3]1). In sheet2 I only need the info from Column2 and Column3. Is there any way to do this from a…
-
Changing % complete using a formula in another cell
I know you cannot use a formula in a "% Complete" field. Is there a way to update "% Complete" from a formula in another column (something like a "helper" column)? I have a "Task Status" column with drop down values of Not Started, In Progress, and Complete. I would like to change the value of "% Complete" when I change…
-
SUMIF and WEEKNUMBER
I have a connector that pulls in all tickets closed after 1/1/2020, and the points associated with each. I want to sum up the points for all tickets closed each week. My formula is: =SUMIF(Week:Week, 1, [Story Points]:[Story Points]) I did some searching and found you can't sum on formulas, and added the 'Value' column…