Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Formulas and Functions
Discussion List
-
First post 10/19/18,Last post 01/13/20Hello everyone, I am looking to have an information sheet that is looking for several criteria with "and" and "or". For example, I want the formula to count if the other sheet has "Priority 1" and "John…Formulas and Functions1726diegoartorres -
Time tracking / Formulas.AnsweredFirst post 01/10/20,Last post 01/13/20Hello, I'm trying to setup the following: • Time tracking spreadsheet with the following columns: Date, Client, Project, Time (increments of .25 hrs) • either in the same sheet or different: Ability to either loop through each row and spit…Formulas and Functions573Mike Banom
-
First post 01/08/20,Last post 01/12/20Hello I would like to add multiple contacts to a single contact cell for one task with a formula, is there a away to do this? Can Group Management be utilized? Thank youFormulas and Functions263cthrasher97141 -
Static Date/Time StampAnsweredFirst post 01/09/20,Last post 01/12/20I've looked around and I realize that this is a feature many people want within smartsheet. I was wondering if anyone has a workaround for this. I want to automate the start date to today but I don't want it to change so using =TODAY () wo…Formulas and Functions263Zachary Mitchell
-
How to use IF(ISBLANK and another IF formula?Accepted AnswerFirst post 01/09/20,Last post 01/12/20Hello, I am trying to create a formula and I need some help. The formula would be in a column which have a single select dropdown option: Update. The formula would use information from two columns. The column names are Level and Late…Formulas and Functions213Tina
-
Comparison of two cell with smartsheetAccepted AnswerFirst post 01/12/20,Last post 01/12/20Hi community I'm trying to do something pretty easy but couldn't go further on my own. I have one column where users from one site will answer in every cells "Yes, maybe, no" through a 3 choices list (column Baudouin) that show…Formulas and Functions199Michael ROBASTON
-
First post 01/11/20,Last post 01/11/20I have sheet 1 with cell A and cell B, I would like to manually enter cell B and have cell A auto populate by searching/referencing sheet 2. best, OwenFormulas and Functions133Owen Smith
-
Slow updates on Formulas and Cell LinksAccepted AnswerFirst post 01/08/20,Last post 01/11/20The last 24 hours have been a nightmare. I have been doing maintenance on some of our data sheets which have formulas and that link to roll up sheets. The cells are taking a long to to update -and in some cases haven't updated at all (i.e…Formulas and Functions326Allison Jones -
First post 01/10/20,Last post 01/10/20Hello, I would like the "Bid Back" date to highlight in red if it is past the date in red in the Trade column. I would also like the "Bid Back" date to highlight in Yellow if it is within 3 days of the red date in the t…Formulas and Functions256Tania Nassar
-
RYG formula with a date referenceAccepted AnswerFirst post 01/10/20,Last post 01/10/20Looking for formula help with RYG referencing a date column. I want a green ball if the expiration date is more than a year away, yellow ball for expiration between today and 365 days and red for any date in the past.Formulas and Functions219rymurph
-
If outcome of Formula is 0 show blankAccepted AnswerFirst post 01/10/20,Last post 01/10/20Hi All, I'm using a formula to count how many stores we have opened in a certain country/month. This information is then used in a chart in a dashboard. The problem is that when we haven't opened any store it shows a zero. This zero is al…Formulas and Functions284Jeffrey Wagemans
-
Limit Results to Specific YearAccepted AnswerFirst post 01/10/20,Last post 01/10/20I have added the number of closed projects to a report by getting the total from the "Status" column in another sheet, like this. =COUNTIF({ARC Range 2}, "Closed") There is also a "Date" column in the sheet.…Formulas and Functions205Mike Jones
-
Auto Checkbox: Only if All Children / Decedents are CheckedAccepted AnswerFirst post 01/10/20,Last post 01/10/20Good Day All: I am trying to modify a basic Formula to Auto Checkbox the Parent only if All the Children / Decedents are Checked. =COUNTIFS(DESCENDANTS(), 1) ThanksFormulas and Functions163Ray B
-
First post 07/24/19,Last post 01/10/20Getting an unparseable error when i do this: =COUNTIFS(DESCENDANTS([Final and Locked]824, 1)) Basically, I just want it to automatically count the number of checkboxes in the next column so when new children are added by other users, I d…Formulas and Functions293movieloverron
-
IFERROR statement with an If(and... formulaAccepted AnswerFirst post 01/09/20,Last post 01/10/20I need help. I can get the if/and statement to work, BUT if the cell is blank it gives one of the options. =IFERROR(IF(AND([Bottom OP]1 >= [Spec - Low]1, [Bottom OP]1 <= [Spec - High]1)), "In Spec", "Out of Spec"…Formulas and Functions279beth_linder28141
-
First post 07/12/19,Last post 01/10/20I have a start time and end time in my smartsheet but need to calculate hours worked. Has anyone used a formula before to do this? if so can you pass along?Formulas and Functions439JoAnn Merritt
-
First post 01/09/20,Last post 01/10/20I am trying to find a way to allow users to select multiple criteria, where each criteria has a score. And once selected, have a column add up the scores for all criteria selected. For Example: Criteria Score Cat …Formulas and Functions263MCorbin
-
Counting Children on Multiple CriteriaAccepted AnswerFirst post 01/10/20,Last post 01/10/20Hi all I am using the following formula in a parent row which has 10 child rows: =IF(COUNTIF(CHILDREN(), "Complete") < 10, "Not Done", "Done") It shows Done as soon as all the children rows have the word Co…Formulas and Functions273[email protected]
-
How to use IF(ISBLANK and another IF formula?Accepted AnswerFirst post 01/10/20,Last post 01/10/20Hi, I am using this formula =IF(AND(NOT(ISBLANK([Latest Update]@row)), [email protected] = 2), "Update", "") and I would like to add =IF([email protected] = 1, "Project Update") if it is Not Project Update it it needs to b…Formulas and Functions132Tina
-
Amount of Requests per LawyerAnsweredFirst post 01/02/20,Last post 01/10/20Hello, I'm trying to find out how many requests a lawyer gets per month based on a few things: -AFID (Auto Fill-In Date) -Type of Request = FOIA -Lawyer's Staff name -Status (Red, Yellow, Green, Blue; However, these are not in as words, th…Formulas and Functions3014fennerb
-
First post 01/05/20,Last post 01/10/20I am trying to dashboard my annual projected revenue. This will factor on the amount of the job and the expected completion date of the job. I know the scheduled job date and the expedted amountof time it takes to complete a job so it seem…Formulas and Functions394Brian Erdelyi -
Status Field - Conditional Formatting or If Function?Accepted AnswerFirst post 01/09/20,Last post 01/10/20I am working on creating a tracking sheet for a longitudinal study, where clients need to be re-interviewed every six months until they are discharged from the program. I have a status field for each time point, and have used conditional f…Formulas and Functions301Lee Ratzlaff -
Update Date when Health ChangesAnsweredFirst post 01/09/20,Last post 01/09/20Hi All, I've been tasked with finding a way to automate a column in a health-tracker for our PMO. Here is the ask: "When [Health]@row changes to Any Value (red/yellow/green/grey), update the [Date of Change]@row with the date the ch…Formulas and Functions203@emipathy -
First post 01/09/20,Last post 01/09/20We have created a sign in form for our business. When a customer arrives they fill out the form. In the form is a dropdown of different areas of our business. We are trying to count on a sheet how many times an area in the dropdown has bee…Formulas and Functions224Donnym
-
First post 01/09/20,Last post 01/09/20This discussion has been moved.Formulas and Functions10Alejandra -
Number to Text FormulaAccepted AnswerFirst post 01/09/20,Last post 01/09/20hello everyone, i am trying to create a formula that will take a series of numbers (UPC) and convert them into a text. I am currently trying to implement the barcode scanner to a form. ex: on the form, i will scan the product/equipment, an…Formulas and Functions332Cristian Rangel
-
Health symbols formulaAnsweredFirst post 01/09/20,Last post 01/09/20Hi, I am a new user and I am trying to design a sheet for us. I am trying to write a formula to have the symbols return the following: If % complete = 100%, return gray; If target day is today and it is less than 100% complete, return Re…Formulas and Functions191Yvonne "Buffy" Frongia
-
Reference Sheet Summary fields in formula in sheetAccepted AnswerFirst post 01/09/20,Last post 01/09/20I need to create a formula that concatenates (JOIN or "+") several fields in my sheet summary, back into a column in my sheet. What is the syntax I need to use to be able to reference sheet summary fields? Thanks!Formulas and Functions245Chamilla
-
First post 01/09/20,Last post 01/09/20I have formatted my RYG balls to change according to the status of the task; Not Started = Grey, In Progress = Yellow, Complete = Green, and so on. I want Red = Not completed, and also past due. This is what I have: =IF([email protected] = &quo…Formulas and Functions255rbuckner -
First post 01/07/20,Last post 01/09/20Hello, I am looking at an existing sheet and trying to pull that information over to another sheet. The current column is utilizing a check box and I would like to pull that information over based on a specific number that is being utili…Formulas and Functions278Keith McCloskey
