Formulas and Functions

Formulas and Functions

 

Discussion List

  • Phil Wightman
    Using COUNTIFSQuestion
    Question Phil Wightman 5 views 0 comments Started by Phil Wightman
    First post 08/09/20,Last post 08/09/20
    Hi, I am using the following formula to count those occasions when CSOD (unit) is impacted by CFCD (unit) and the status of the impacts is either 'conceptual' or 'complete' and it does not work. If I limit it to only counting 'conceptual'…
    Formulas and Functions50
    Phil Wightman
  • Cristina Andersen
    Question Cristina Andersen 6 views 0 comments Started by Cristina Andersen
    First post 08/08/20,Last post 08/08/20
    Hi all, here's my scenario. I have four sets of cars that get moved out of my location. They come sporadically throughout the month. Im trying to figure out a formula that would average the turn time on a particular set of cars. Any ideas?…
    Formulas and Functions60
    Cristina Andersen
  • Leonard Eldić
    Question Leonard Eldić 9 views 0 comments Started by Leonard Eldić
    First post 08/08/20,Last post 08/08/20
    Hi guys, I'm a new Smartsheet partner trying to develop a custom solution for a client. So the client requests Dashboard with up to date leaderboard on it. I've made the leaderboard and connected it to other data so it calculates victories…
    Formulas and Functions90
    Leonard Eldić
  • Erin Becker
    Answered - Pending Review Erin Becker 9 views 1 comment Most recent by Sean Morgan
    First post 08/07/20,Last post 08/08/20
    Hello there, I have a sheet setup with 4 columns of dated. Project Owner Completion Deadline, Project Owner Actual Completion Deadline, Project Auditor Completion Deadline, and Project Auditor Actual Completion Deadline. I am trying to fi…
    Formulas and Functions91
    Erin Becker
  • saraha83081
    Answered - Pending Review saraha83081 14 views 2 comments Most recent by lewis hamilton
    First post 08/07/20,Last post 08/08/20
    Hello, I'm trying to create a formula that will display a specific value if a date falls within a certain range. Any assistance would be greatly appreciated. If “Target Update or Replacement Date” is between 10/01/20 and 09/30/21, then &…
    Formulas and Functions142
    saraha83081
  • Lynn Strahm
    Answered - Pending Review Lynn Strahm 9 views 2 comments Most recent by lewis hamilton
    First post 08/07/20,Last post 08/08/20
    I'm trying to count the number of quotes completed by week. The challenge is there are two departments who may work on a quote and each enter their own completion date. Sometimes only one department works on a quote so only one of the tw…
    Formulas and Functions92
    Lynn Strahm
  • laura.buchanan
    laura.buchanan 1.8K views 23 comments Most recent by Andrea Antillon
    First post 09/16/18,Last post 08/08/20
    Can anyone tell me what might be wrong with this formula? I'm trying to count the number of items that are complete, as noted by the presence of a date in the date completed field. I need to know the number of fields that have a date in 2…
    Formulas and Functions178423
    laura.buchanan
  • aschneiderheinze74206
    Question aschneiderheinze74206 9 views 0 comments Started by aschneiderheinze74206
    First post 08/08/20,Last post 08/08/20
    I have two Sheets, one with a list of full course master names (e.g., ABS-435-BL-6W-1D-Master), and another sheet with a list of course sections (e.g., ABA 435 BL 6W). Is there a way to use CONTAINS in a cross-reference formula to check al…
    Formulas and Functions90
    aschneiderheinze74206
  • Sandra Healey
    Question Sandra Healey 6 views 0 comments Started by Sandra Healey
    First post 08/08/20,Last post 08/08/20
    I am looking for a way to create a test script using forms. Multiple users would complete the script which would populate a single sheet that could be reported off...... If a tester completes a step in the script (form1), they would subm…
    Formulas and Functions60
    Sandra Healey
  • Chad Dixon
    Answered - Pending Review Chad Dixon 19 views 2 comments Most recent by Lorraine Metler
    First post 07/15/20,Last post 08/07/20
    Hello - I will be creating ~35 project plans for 35 customers. All will have the same set of tasks. Within each of those sheets, I will have the same (4) summary fields, that capture the following: milestone status, # of outstanding miles…
    Formulas and Functions192
    Chad Dixon
  • Ray B
    Accepted Answer Ray B 9 views 4 comments Most recent by Ray B
    First post 08/07/20,Last post 08/07/20
    Smartsheet I am trying to use this Formula to calculate % Complete based on Checkbox, however the Checkbox is a different Column Called Done, not under the % Column. Can I do that? Existing Formula: =ROUND(IF(COUNTIF(DESCENDANTS(), 1) / CO…
    Formulas and Functions94
    Ray B
  • Davis Dye
    Accepted Answer Davis Dye 12 views 4 comments Most recent by Davis Dye
    First post 08/07/20,Last post 08/07/20
    Good Afternoon! I am trying to sum children rows where certain status' exist where the Pick-Up Date is today, within the next two days, and in the future beyond that. (Really, 3 formulas). (Image) I tried applying the following formula bef…
    Formulas and Functions124
    Davis Dye
  • Sebastian Avila
    COMPARE COLUMNSQuestion
    Answered - Pending Review Sebastian Avila 9 views 1 comment Most recent by [email protected]
    First post 08/07/20,Last post 08/07/20
    Hi have two columns with ID´s and i want to compare them see, if an Id number has a match or a mismatch in the other column. What kind of formula de you recomend to do this? I used Vlookup: =VLOOKUP([NÚMERO DE SINIESTRO]1; {SINIESTROS CF};…
    Formulas and Functions91
    Sebastian Avila
  • Lee Ratzlaff
    Accepted Answer Lee Ratzlaff 43 views 5 comments Most recent by Paul Pindell
    First post 01/24/20,Last post 08/07/20
    Hello! I am trying to create an IF statement to show the federal fiscal quarter an event occurred. Could someone please help troubleshoot my syntax? Federal Quarters: Q1: Oct, Nov, Dec (10, 11, 12) Q2: 1, 2, 3 Q3: 4, 5, 6 Q4: 7, 8, 9 Not …
    Formulas and Functions435
    Lee Ratzlaff
  • Jamie Wisegerber
    Answered - Pending Review Jamie Wisegerber 14 views 7 comments Most recent by Jamie Wisegerber
    First post 07/31/20,Last post 08/07/20
    Hi Community. I'm hoping someone can help me out. I created a task tracking sheet. A general rule is that our reporting month is always two month behind today. In my sheet summary I have a formula using index match, which works perfectly t…
    Formulas and Functions147
    Jamie Wisegerber
  • Irina Iatco
    SUMIFS FormulaQuestion
    Answered - Pending Review Irina Iatco 16 views 3 comments Most recent by Irina Iatco
    First post 08/06/20,Last post 08/07/20
    Hi, I am trying to sum the numbers in the first column where the states are CA, CO, DC and IA. Could you please help. I a still learning formulas in Smartsheet. Thanks! (Image)
    Formulas and Functions163
    Irina Iatco
  • Neil Fleming
    Answered - Pending Review Neil Fleming 12 views 13 comments Most recent by Neil Fleming
    First post 08/06/20,Last post 08/07/20
    Simple VLOOKUP based on text field returns #NO MATCH. Driving me crazy!: (Image) (Image) Ideas?
    Formulas and Functions1213
    Neil Fleming
  • Sarah Lanahan
    Answered - Pending Review Sarah Lanahan 22 views 5 comments Most recent by Sarah Lanahan
    First post 07/30/20,Last post 08/07/20
    Hi I'm trying to count the number of teachers from different cohorts that have not yet given feedback through a form, so the cells with #NO MATCH. I have all of the data in 1 SS and am totally and running metrics in another. In the sheet…
    Formulas and Functions225
    Sarah Lanahan
  • Nikki McIntosh
    Question Nikki McIntosh 9 views 0 comments Started by Nikki McIntosh
    First post 08/07/20,Last post 08/07/20
    Hello. I'm new to formulas and need help. I'm trying to figure out how to get the total % complete for a column of check boxes. We need to know the % complete by milestone (which we figured out) AND the total % complete. We use parent rows…
    Formulas and Functions90
    Nikki McIntosh
  • Anna Pelipas
    Answered - Pending Review Anna Pelipas 13 views 6 comments Most recent by Michael Heisler
    First post 08/06/20,Last post 08/07/20
    Please help, what's wrong? It couldn't be parsed... =IF(OR([Исполнитель (из первичной)]4 <> Исполнитель4); ([Стоимость работы (с НДФЛ) (из первичной)]4 < [Cтоимость работы (с НДФЛ)]4));"ДА";"НЕТ") Thank you in …
    Formulas and Functions136
    Anna Pelipas
  • Cassie Sprague
    Date Range FormulaAccepted Answer
    Accepted Answer Cassie Sprague 9 views 2 comments Most recent by Cassie Sprague
    First post 08/07/20,Last post 08/07/20
    Hi, I'm trying to set up a formula to count the number of requests that were submitted between a specific date range. Below is the formula that I've written, however I'm still receiving an invalid operation error. Can anyone help me with t…
    Formulas and Functions92
    Cassie Sprague
  • vipa2000
    Answered - Pending Review vipa2000 11 views 5 comments Most recent by Michael Heisler
    First post 08/06/20,Last post 08/07/20
    In the below - column Principal Check I have put: =if([Principal survey drawing required?]2="Yes",[Principal drawing validated?]="Awaiting response","Not Required") I am wanting the Principal drawing validated…
    Formulas and Functions115
    vipa2000
  • Ray B
    Answered - Pending Review Ray B 9 views 4 comments Most recent by [email protected]
    First post 08/06/20,Last post 08/07/20
    Smartsheet Community: I am trying to Count If the Checkbox is Checked, the Date is Less than August 5 or Blank. I know I am close but can not see finish the Formula Correctly. Current Formula Below: =COUNTIFS({Issue / Defect UAT LOG Range …
    Formulas and Functions94
    Ray B
  • Jason Jones
    Answered - Pending Review Jason Jones 18 views 2 comments Most recent by Jason Jones
    First post 08/07/20,Last post 08/07/20
    I have been working on this for hours and can’t seem to figure it out and can’t find proper support on line. This one is a time sensitive metric I am trying to get on our dashboard for our stakeholders to see. Any help you can give me woul…
    Formulas and Functions182
    Jason Jones
  • Emerus CCC
    Question Emerus CCC 9 views 0 comments Started by Emerus CCC
    First post 08/07/20,Last post 08/07/20
    I am trying to reference an automated creation column from sheet A to populate date AND time in a column in sheet B. I have been successful in the reference, but then have to format the receiving column to date format due to invalid data…
    Formulas and Functions90
    Emerus CCC
  • Emerus CCC
    Auto CheckboxQuestion
    Answered - Pending Review Emerus CCC 14 views 3 comments Most recent by Emerus CCC
    First post 08/05/20,Last post 08/07/20
    I would like a formula to check a box for open cases. I have a start date column and an end date column. Only check the box when there is a start date and no end date entered. Thank you!
    Formulas and Functions143
    Emerus CCC
  • SteveReed@WK
    Answered - Pending Review [email protected] 18 views 1 comment Most recent by [email protected]
    First post 08/05/20,Last post 08/07/20
    I know my question itself is confusing, so let me explain. I have configured data to come into Smartsheet from SharePoint via Power Automate. It is depositing some basic metadata into a "From SharePoint" sheet (image included her…
    Formulas and Functions181
    [email protected]
  • Damon Lloyd
    COUNTIFS + ORAccepted Answer
    Accepted Answer Damon Lloyd 38 views 2 comments Most recent by Damon Lloyd
    First post 08/03/20,Last post 08/07/20
    Each quarter completed jobs get moved to a Completed Sheet for that relevant quarter. However, some of the tasks done on that job needs to be reported for a previous quarter. An example of a task would be a Preflight Review, which takes …
    Formulas and Functions382
    Damon Lloyd
  • Lindsey Cunningham
    Question Lindsey Cunningham 8 views 0 comments Started by Lindsey Cunningham
    First post 08/07/20,Last post 08/07/20
    I am trying to create a budget sheet that roll up the information inputed by mangers on 10 different sheets. Each manager has a grid like the one below and I want to duplicate that as a summation of information from each sheet. So a summat…
    Formulas and Functions80
    Lindsey Cunningham
  • Nick Rozaklis
    Answered - Pending Review Nick Rozaklis 24 views 3 comments Most recent by Nick Rozaklis
    First post 08/06/20,Last post 08/07/20
    Hello! I have a list of 38 objects (planes, trains, automobiles, what have you...) and I want to find out what the percentage complete is for either based on status. Is there a way for me to gather a total % complete based on status? For …
    Formulas and Functions243
    Nick Rozaklis