-
series fill with numbers
This is probably an easy fix, but just like in excel, how do I drag and fill a number series? So if the first cell is #1, grab the bottom right corner and drag for 10 cells, I now want the cells to be 1,2,3,4,5,6,7,8,9,10.
-
At Risk
Hi , I been working on my smartsheet , and I didn't get the flag at the "At risk" Column. I did my formula to get my red flag , but I just get a 1 …
-
Copy of my responses
I'm not sure if this was already addressed in a previous post or not so I appreciate your patience. I created a registration form that has 6 choices for respondents to choose from. Is there a way to format the "copy of my response" email to only include the specific choice they picked? Currently, the email includes all 6…
-
Sheet Summary cell reference changing?
Hello, I have built a sheet summary with formulas that look something like this, =COUNTIF(Provider1:Provider154, "Syringa"). The problem that keeps happening is that the cells I referenced to count, are changing randomly. For example, I will reopen the sheet and the formula looks like this, =COUNTIF(Provider24:Provider75,…
-
Form with required attachment if a specific field is chosen
I have created a form and in this form if the user chooses "remove" then I would like to require that documents be attached. Is this possible?
-
Can information be pushed into a SmartSheet from an email message
Hi there, I am curious to find out if I can embed a button (or link) into an email that would make an entry into a SmartSheet. Let's say I want to send an email which asks the recipient to choose one of two options. I could send them to a SmartSheet form and have them fill it out, but what I would rather do is have them…
-
Copy row data from one sheet to another
Is is possible to create a rule or manually copy data from one sheet to another? Not all the columns would match between the two sheets. We would need the ability to map which columns should be copied from one sheet to another.
-
Make sub sheets from the main sheet
Hi guys,I have the main sheet with a lot of data (rows and columns). I want to make sub sheets, which should include all rows from the main sheet, but not all columns. I also want to have functionality if I change something in sub sheet, I want it to be updated in the main sheet... Also to work in the opposite direction -…
-
Inactive Forms - Changing displayed text
Hello all, Our group is switching from our current set up tracking and submitting to smartsheet. Is there anyway to edit the automated message when people go to the form? E.g. "Please discontinue use and.."
-
Nonworking Days but tasks must be completed
So I'm setting up a smart sheet so that I have a holiday break for Christmas and Thanksgiving. My problem I'm having is that when I go to start one task after the next, it'll start a task and carry it through the holiday break then complete it after the break. Is there a way to set it so that if a task won't be comlpleted…
