Formulas and Functions

Formulas and Functions

 

Discussion List

  • Christina Riot
    Question Christina Riot 3 views 0 comments Started by Christina Riot
    First post 03/28/20,Last post 03/28/20
    Is there a know issue with this or is there a max number of selections with forms? I have a contact list of 3000 names and it is not appearing as a drop down in my form. Other drop down's I have are indeed showing up and I am doing nothi…
    Formulas and Functions30
    Christina Riot
  • majdesber
    majdesber 61 views 2 comments Most recent by Kaleb Wade
    First post 05/18/19,Last post 03/28/20
    Hello, Is there any formula to post(return) the name of the logged in user? I am trying to record the user name of the person who checked a box. for example, If I want to post a date when a box was checked, I write: =IF(Closed1 = 1, TODA…
    Formulas and Functions612
    majdesber
  • dave.mcpherson56751
    Logic and summaryUnanswered Question
    Question dave.mcpherson56751 8 views 0 comments Started by dave.mcpherson56751
    First post 03/28/20,Last post 03/28/20
    Hi, We have 400 locations managed by approx 30 managers. I am trying to use logic to build a form that when manager 1 chooses their name they only see sites relating to them. To achieve this i have created columns with a drop down for eac…
    Formulas and Functions80
    dave.mcpherson56751
  • Daniella Canada
    Accepted Answer Daniella Canada 19 views 2 comments Most recent by Daniel Hampshire
    First post 03/18/20,Last post 03/28/20
    We are using the card view to provide use case testing for our clients. Currently, the sub-tasks roll up to a parent row which makes the card. However, when sub-tasks are marked done (using the checkbox functionality in cards), I can't fig…
    Formulas and Functions192
    Daniella Canada
  • Iris Fuentes
    Question Iris Fuentes 5 views 0 comments Started by Iris Fuentes
    First post 03/28/20,Last post 03/28/20
    Hello, I have the following formula in excel but it did not transfer to Smartsheet. Is there a way to get this formula over? =LOOKUP(F2,{-100,7,14,21,30,45,90,180},{"0-7","7-14","14-21","21-30",&quo…
    Formulas and Functions50
    Iris Fuentes
  • Mike Boyer
    Question Mike Boyer 11 views 0 comments Started by Mike Boyer
    First post 03/28/20,Last post 03/28/20
    Status - Column Heading Open - Drop Down Closed - Drop Down CIT - Drop Down Wanting to count how many "open"
    Formulas and Functions110
    Mike Boyer
  • Kendra Roach
    Answered Kendra Roach 10 views 1 comment Most recent by Andrée Starå
    First post 03/27/20,Last post 03/27/20
    I am wondering if I can have a secondary question become "live" on a form based on an answer to a question?
    Formulas and Functions101
    Kendra Roach
  • Sonny Mendoza
    Accepted Answer Sonny Mendoza 10 views 3 comments Most recent by Andrée Starå
    First post 03/27/20,Last post 03/27/20
    I have linked many sheets so now when I try and select a drop down within a cell I cannot because this "Used in formula on" window hovers over my select options. Is there a way that I can turn this off?
    Formulas and Functions103
    Sonny Mendoza
  • Kasey Bernard
    Question Kasey Bernard 5 views 0 comments Started by Kasey Bernard
    First post 03/27/20,Last post 03/27/20
    I'm trying to do a countif statement that checks if a request is approved or denied, and the return to work date is great than today's date. I've tried multiple ways and can't figure it out. Any ideas? https://us.v-cdn.net/6031209/uploads/…
    Formulas and Functions50
    Kasey Bernard
  • Sylvia Elizabeth
    Accepted Answer Sylvia Elizabeth 14 views 6 comments Most recent by Sylvia Elizabeth
    First post 03/20/20,Last post 03/27/20
    Hi! I'm trying to type a formula which could tell me the percentaje of the cells that are in color green, those cells are painted in green when I type the word "Listo", so I found that formula (showed in the image) in the communi…
    Formulas and Functions146
    Sylvia Elizabeth
  • Morgan Frost
    Question Morgan Frost 4 views 0 comments Started by Morgan Frost
    First post 03/27/20,Last post 03/27/20
    Formula wizards! Can you help me with this one? I have a column for Primary Team (single select) and a column for Secondary Teams (multi-select). I want to drive a report widget to include rows where a certain team, let's say "Team X…
    Formulas and Functions40
    Morgan Frost
  • Christina Reid
    Accepted Answer Christina Reid 29 views 4 comments Most recent by Christina Reid
    First post 03/12/20,Last post 03/27/20
    We have tracking sheet that we use to track client accounts that are transferring. I want to take a different file that shows accounts that have confirmed been transfer and use Data Uploader to have the information on the input sheet eith…
    Formulas and Functions294
    Christina Reid
  • Laurie Bearden
    Formula using <>Answered Question
    Answered Laurie Bearden 11 views 5 comments Most recent by Laurie Bearden
    First post 03/27/20,Last post 03/27/20
    I'm trying to create a formula that will return a red, yellow, or green ball. I saw the below formula on someone else's comment a while back, but wasn't able to find it today. Right now my formula is: =IF([Late Tasks]@row > 0.75 * [T…
    Formulas and Functions115
    Laurie Bearden
  • Al ISS
    Answered Al ISS 11 views 1 comment Most recent by Paul Newcome
    First post 03/27/20,Last post 03/27/20
    One range in my COUNTIFS formula has several columns included. If I use this range on COUNTIF (no S on it), it works perfectly but, when I include in COUNTIFS, it does not work. (#Incorrect Argument Set). I then split all these columns in …
    Formulas and Functions111
    Al ISS
  • Mommaduck
    Answered Mommaduck 17 views 10 comments Most recent by Paul Newcome
    First post 03/26/20,Last post 03/27/20
    I have a column with the time (hh:mm) an interaction took place. I have another (currently blank) column for shift that I need to populate from the time. The "shift" during which an interaction took place would be: 7Am-12:59…
    Formulas and Functions1710
    Mommaduck
  • Dave Moe
    Question Dave Moe 9 views 0 comments Started by Dave Moe
    First post 03/27/20,Last post 03/27/20
    Good morning, I am looking to pull the data in a cell if two other criteria are met in other cells in the same row. for example, I have a sheet called Daily reporting that is receiving form submissions. I want to pull the text in [Qualit…
    Formulas and Functions90
    Dave Moe
  • Melissa P-B
    Answered Melissa P-B 42 views 19 comments Most recent by Paul Newcome
    First post 03/12/20,Last post 03/27/20
    Greeting all. I am my wits end on this one because I'm pretty sure this can be done but I'm not quite finding out how. The problem I'm trying to solve is as follows: We manage multiple events in Smartsheet. We use forms for sign ups so all…
    Formulas and Functions4219
    Melissa P-B
  • NBudd
    IF Formula IssueAnswered Question
    Answered NBudd 12 views 3 comments Most recent by NBudd
    First post 03/27/20,Last post 03/27/20
    Hey all! This is so simple but having issues. I want to show "1" "2" or "3" for "Low" "Medium" "High" =IF([Level of Change]@row, = Low, "1", IF([Level of Change]@row, =…
    Formulas and Functions123
    NBudd
  • bradleyesmith86431
    Answered bradleyesmith86431 14 views 5 comments Most recent by Paul Newcome
    First post 03/27/20,Last post 03/27/20
    Good morning, I am trying to add up total hours of a {Project Type} Column if the project type contains the following: Implementation, Implementation - Small Market, and ELD Implementation =SUMIFS([Hours Worked]:[Hours Worked], Date:Dat…
    Formulas and Functions145
    bradleyesmith86431
  • Thomas Yonker
    Accepted Answer Thomas Yonker 12 views 4 comments Most recent by Paul Newcome
    First post 03/26/20,Last post 03/27/20
    Hi, I've got a project I've imported from MSProject, and my smartsheet has a % complete column. I'm trying to use COUNTIF to identify the number of tasks that are unstarted, those that are complete, and those that are in progress using th…
    Formulas and Functions124
    Thomas Yonker
  • Avantika Murthi
    Answered Avantika Murthi 15 views 2 comments Most recent by Paul Newcome
    First post 03/27/20,Last post 03/27/20
    Ive been trying to add multiple conditions in to calculate some values for my Sheet Summary, but I cant seem to add more than 2 conditions. Each of them work individually & with 2 conditions, but when i add the third condition it alway…
    Formulas and Functions152
    Avantika Murthi
  • Jessintha Nathan
    Answered Jessintha Nathan 9 views 3 comments Most recent by Debbie Sawyer
    First post 03/27/20,Last post 03/27/20
    Hi! How do I sum a specific category (Primary Column) with reference to a separate sheet. I keep getting multiple errors: https://us.v-cdn.net/6031209/uploads/332/RGPFM8JD7HIF.png
    Formulas and Functions93
    Jessintha Nathan
  • amiller66941
    End of Month FunctionAccepted Answer
    Accepted Answer amiller66941 9 views 7 comments Most recent by Paul Newcome
    First post 03/26/20,Last post 03/27/20
    Good afternoon all, I'm trying to figure out how to apply the =EOMONTH(A1,0) from excel into a smartsheet. Any guidance on this would be most appreciated! Thanks!
    Formulas and Functions97
    amiller66941
  • rymurph
    Formula for COUNTIFAccepted Answer
    Accepted Answer rymurph 29 views 25 comments Most recent by Paul Newcome
    First post 03/23/20,Last post 03/27/20
    We have a form for tracking sick time. Employee must fill out the form on first day of sick. They have to fill out the same form again when they return to work. These are both tracked in the Status column (Sick and Returning). We a…
    Formulas and Functions2925
    rymurph
  • s_mawer
    Answered s_mawer 19 views 9 comments Most recent by Debbie Sawyer
    First post 03/26/20,Last post 03/27/20
    Hi all I'm pulling my hair out trying to figure out the correct way of writing a Countif a cell is either blank OR contains a date before a date referenced in a different column. I've been playing around with =COUNTIF({DateClosed},OR(ISBLA…
    Formulas and Functions199
    s_mawer
  • Sharareh Zand
    OR in SUMIF functionAnswered Question
    Answered Sharareh Zand 8 views 2 comments Most recent by Paul Newcome
    First post 03/27/20,Last post 03/27/20
    Hello, I am trying to use OR in SUMIF function as below but get invalid operation error: =SUMIFS({Q1 '20- LE}, {Group}, [Primary Column]82, {Project Type}, [Column2]81, {Confidence Level}, [Column11]83) + SUMIFS({Q1 '20- LE}, {Group}, [P…
    Formulas and Functions82
    Sharareh Zand
  • Florence Li
    Florence Li 9 views 1 comment Most recent by Andrée Starå
    First post 03/27/20,Last post 03/27/20
    I have one case,want to mark the origin value,for example: https://us.v-cdn.net/6031209/uploads/002/28PCFK7G2AA6.png How can I do this?
    Formulas and Functions91
    Florence Li
  • Jessintha Nathan
    Answered Jessintha Nathan 21 views 3 comments Most recent by Jessintha Nathan
    First post 03/21/20,Last post 03/27/20
    Hi! How do I calculate 13 weeks average for a series of data in a column? I need the formula to detect every incremental week add of data. Thank you!
    Formulas and Functions213
    Jessintha Nathan
  • chris.italiano78351
    Accepted Answer chris.italiano78351 18 views 9 comments Most recent by Andrée Starå
    First post 03/25/20,Last post 03/26/20
    Good Morning Hope someone can help me. I want to keep track of the accumulative total for each spreadsheet. For example see below - Tomorrow when i enter in Thursdays actual data of 5 - i would like: The bottom total to add up to Target to…
    Formulas and Functions189
    chris.italiano78351
  • Beronica Muller
    Answered Beronica Muller 6 views 1 comment Most recent by Paul Newcome
    First post 03/26/20,Last post 03/26/20
    I am trying to create a formula to capture the total number of inquiries by plan group name?  I can use the formula =COUNTIFS({National Alliance Operation Inquiries Range 2}, "GROUP NAME", however, I have over 200 groups to choos…
    Formulas and Functions61
    Beronica Muller