-
Updating Average of most recent cells?
Hello! Quick question I've been stumped on. I have a sheet that tracks hours worked on different projects each month in a year. I want there to be a cell that displays the average of the most recent 3 months. Of course, I'd want this to update when a new month is entered. That value would be used along with the "hours…
-
Nested ranges in INDEX/COLLECT??
I need to pull in all of the email addresses from a sheet into another sheet so that my workflow can alert the people listed in that cell. I have the cell set up as a contact list allowing multiple contacts. I need to pull all the emails for "Anywhere US" where the level is "Major" into the sheet that has my workflow when…
-
Trying to figure out how to leverage a name to autofill assigned to in children tasks.
I have a sheet where people are picking up open assignments. This is being linked to the master sheet with the Parent and children tasks. I am trying to figure out how the "pick up assignment" can auto fill in the "assigned To" child tasks once the Pick up assignment has been filled out? See attachment for more detail?
-
Formula for Duration Between 2 Date Columns
I need a formula for a duration of days between 2 date columns. I have no idea how to do this, as I am a new smartsheet user and not familiar with coding or formulas. Any help would be GREATLY greatly appriciated!!! Please view attached. Thanks!
-
Formula Assistance with Linking Sheets
Hi! I have created a sheet that uses a form for requests when my company is wanting a physician to travel. This includes what center/state they're traveling to, their home center/state, the district manager that oversees each center, etc. When a physician is selected I would like for the home center, home state, home…
-
Adding multiplication to a working formula
Hi, I have a SUMIF formula which currently looks at column 4 and if it contains X, it sums the figure in column 3. I now need to take the total and multiply by 1.2%. Have tried a number of ways! Any help appreciated!
-
How do I add months to a date without there being a month duration option?
I'll try to keep from getting too convoluted. On my main sheet I have a "Start Date" that pulls a date from another sheet. I have built a long checklist of items that are due based on this "Start Date". Each item has a different length of duration. There are a couple items at the end of the list that I was looking to use…
-
Formula to Assign Symbol based on a cell's value
This is a complicated one that I once got to work with RGY balls, but cannot figure out how to apply this to the Pain scale emojis. What I am trying to do: (Using the pain scale symbols) Have symbols automatically changed based on the value in the corresponding cell. I am already using a formula to assign a value based on…
-
Run a formula on a destination sheet when rows are moved to it
I'm migrating a manual process we have into Smartsheet, and keep finding new hills to climb! : ) Essentially the process will result in document generation (PDF) after different team members submit info onto a sheet using Forms. First, I found a formula solution that worked for me to combine all sheet data (from columns)…
-
Days to go formula
I have a dedicated column "days to go" I'm trying to get the formula to take the networkdays between today and the start date (accounting for dates in the "holiday helper" column. This formula works but gives a negative number. If the date is 5 days in the future I'd like it to read 5 not -5. If in the past be negative,…