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…
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 f…
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, a…
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 …
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…
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 functionalit…
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 …
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…
Hi Everyone, thanks as always for your help! I have a quick question on the best way to apply default values when adding a new row to a grid view. The idea is that if someone enters a new task name, t…
Hello! So - I am working on building dashboards for my company where we can track To Dos. goals, etc. I have made reports, added them to the dashboards, and connected the report widget back to the dat…
In the Project Management Learning Path via Smartsheet University, I'm running into an issue where it will not allow me to run the 'Regular Task Update Request' weekly on Monday, Wednesday, and Friday…