I'm trying to create a nested formula used in a ticketing system that will total up active status (Open or In Progress) compared to location.
Ticket Active Status for Location = Location <and> Status [Open <or> In Progress…
Formulas and Functions13Jamy Crum
Referring the SUMIF example in the Help article https://help.smartsheet.com/function/sumif, it is not clear to me why =SUMIF([Price Per Unit]1:[Price Per Unit]3, >20, [Transaction Total]1:[Transaction Total]3) has the result 3,115.0…
Formulas and Functions17Elena Codrea
Here is the formula I used: =DATE(YEAR(Date3), MONTH(Date3) + 1). It works great for dates up to the 12th month (December). How
do I modify the formula to go to January of the next year, e.g. 12/01/20 to 01/01/21?
Formulas and Functions10Susan Hildebrant
My formula comes back as #No Match but when I filter, I see the results I need. I am hoping you can assist!
I am trying to calculate the amount of time spent for a contact person. Here is the formula I have so far:
Formulas and Functions9Stephanie Bauder
Can you change formulas to make "Not Started" be the same as if it was blank? If I deleted the Not Started lines then my parent row would match my child/ children rows. (See snip # 2). I'm not sure if it's possible since you can'…
Formulas and Functions12Josh Canady
Hoping someone can help with this as it seems possible... I have a sheet for contacts at individual centers across a state. There are roles assigned to the contacts, so for example there may be a director, a supervisor and a coordinator.
Formulas and Functions36weswillis
I am wanting to count the number of employees that are working this week. However my current formula does not take into account the number of unique names within a weeknumber. Any help would be apreciated.
Formulas and Functions11Mallory McFall
Hi all! I'm trying to summarize deliverables using the date stamp of when a form was submitted. Unfortunately the way our form is set up, we have employees fill out a form and enter the month and the year separately so our sheet does not h…
Formulas and Functions11Steph Harper
This is my current formula, and it works except that if I have more than the name in the formula also checked in the multi select box it does not count it. How do I change this formula so it counts the name in the multi select box …
Formulas and Functions13Brett Kennedy
Is there any way that I can ensure that at the time of copying the formula the cell reference doesn't change?
Formulas and Functions13Prajna Jain
I'd like to get a list of unique values in a range. I'm finding a lot on the community about how to flag duplicates, but not sure how to get a list where each unique value appears in a cell. Screenshot below is what I'm looking for. My goa…
Formulas and Functions894SYSPK
Hi all -
I'm looking to build out a repeatable process calendar. We have something starting (Intake) on X day, and then a series of activities that take a certain amount of time. I'm looking to replicate the Excel function of (Date + X da…
Formulas and Functions9KLM
I would like my RYG balls to express the following (actual dates, not cell reference):
Green = before 21 August 2020
Yellow = after 21 August 2020
Red = after 28 August 2020
This is my current formula, and although individual state…
Formulas and Functions10LisaB:-)
I am looking to understand how the COLLECT() function nested within the AVG() function works and is evaluated. Using the help files, I found the following example. I am specifically looking at the very last formula where the result is &qu…
Formulas and Functions17Michael Murphy
I've been able to find close approximations to what I'm looking for, but have one missing piece. I have a summary sheet ("summary") that pulls data from another source form evaluation sheet ("source"). Essentially, I ha…
Formulas and Functions16Matt Foss
I am trying to setup some sheet automation as follows:
Program Manager sheet: Tracking ID is auto-generated using auto-numbering
When a new tracking ID is generated would like to populate that new ID into another Master worksheet into next…
Formulas and Functions17Jonathan Kearns
I need a formula that I'm not sure I can do. I have tried many different things, and only have a portion working. I need to be able to determine the "difference" between our $$ bid and either the low bidder, if we are not, or t…
Formulas and Functions8dskpetersen
Formulas and Functions27Doyle54
I need a formula to look at @column1/cell (whatever it is); go into another sheet, find that match/@column1/cell, and then return what is in another column (in the 2nd sheet).
Hopefully, that isn't confusing............
Formulas and Functions22Susan Swisher
Reaching out to the masses to hopefully get some help. I need to pull information from sheet 1 into sheet 2 using the INDEX and MATCH functions.
Sheet 1 that I want to pull information from has:
Task Name column (The …
Formulas and Functions37Ameena Bossier
I have 5 sheets of many cells of data for different work groups within my organization. I need to create ONE summary sheet that totals each of the cells from the 5 sheets.
The only way I can figure out how to do it is by creating th…
Formulas and Functions15Tammy Parker
Hi Smartsheet Users,
I am struggling with the formula HAS with multiple selection drop down values and hoping I could get some guidance here.
Here, i would like to count how many "swimming" classes I have in a week.
Formulas and Functions12Syed Mohd Muhafzal
Q: Is it possible to assign a drop-down list to a single cell and not the entire column?
Formulas and Functions14Rob Myer
The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion).
I want to count how many times a value is repeated in a range that has multi values. I use …
Formulas and Functions5317lcamacho19911
I'm looking to see if there is any formula(or anything else) I could use to change a cell to a specific pre-defined value, if a different cell is CHANGED TO a certain value.
I know that the changed to functionality is available through…
Formulas and Functions53Scott Rae
I use Dynamic View. Dynamic View, unfortunately, only allows 1 single column to be the list of users who can see data in a specific row. Smartsheet is not able to combine multi-contact lists into a single column that is recognized within…
Formulas and Functions23Ryan Michalski
I have question do you know how I can use the same "formulas" for each new ligne generate by the form ?
The formulas has the purpose to take information from another cell.
MT for your help. I tried this tutorial but it d…
Formulas and Functions17Joachim Chenna
I want to allocate hours equally based on a given date range, in excel I could get it work using Eomonth, in Smartsheet, I'm struggling to achieve.
I have attached the image of the formula I got it working in Excel, how do I replic…
Formulas and Functions27UrbanNomad
I am having trouble with my formula. I'm a newbie and my logic be flawed and terrible. Learning in progress. I thought I had received the answer but as it turns out I was still trying to acquire more information. Essentially what I want …
Formulas and Functions25Rigoberto Huizar
Hello! I am relatively new to Smartsheet and I am still in the process of learning excel. One of my sheets is a simple data entry sheet in which I need the Sheet Summary to show the information in the most recent row. I have been using the…
Formulas and Functions22Gabriel Perez-Pujols