Formulas and Functions

Let the community help you with that tricky formula or function! See how others are utilizing the power of formulas and functions to save them time and create more powerful solutions with Smartsheet.
 

Discussion List

  • How do I change a cell value to a symbol
    In Formulas and Functions
    In the automation 'Change cell value', is there a reason that symbols are not included? I want to use the symbols, but base on the response from other team members. The responses are being asked from a Drop Down menu, but I cannot get the …
    Answered - Pending Review
    5 2
    Answered - Pending Review 5 views 2 comments Most recent by Vanessa Cavagnaro
  • Auto Delete Data in Smartsheet
    In Formulas and Functions
    Is there a setting in Smartsheet that will allow me to auto delete data after 30 days?
    Unanswered
    4 0
    Question 4 views 0 comments Started by Andrea Kristina Oconer
  • Lost with vlookup or matching?
    In Formulas and Functions
    I am needing to update a Smartsheet to reflect the date listed in a cell from another Smartsheet. Both sheets have an IP address that can be match on as there are no duplicates. The feeder sheet with the date has 210 entries and master she…
    Accepted
    12 5
    Accepted Answer 12 views 5 comments Most recent by Andrée Starå
  • How to create this COUNTIFS with AND/OR/NOT
    In Formulas and Functions
    I cannot figure out how to create this formula to get the metrics. I can get each individual dept metric correct using =IFERROR(COUNTIFS({(Phoenix) Project Tracker - Aerial Status}, AND(@cell <> "No", @cell <> "…
    Answered - Pending Review
    20 2
    Answered - Pending Review 20 views 2 comments Most recent by KDM
  • IF Function for multiple values
    In Formulas and Functions
    Can someone please help me with the formula where if the column1 has any value from the list (i.e. test1, test2, test3, test4) the output should be "Test Result". I tried this with the formula =IF([Column1]@row, = "Test1&quo…
    Accepted
    4 15
    Accepted Answer 4 views 15 comments Most recent by Aatish Chaudhary
  • Linking Two Sheets to update dynamically When columns are added and removed.
    In Formulas and Functions
    I have two sheets that i want to be linked dynamically. EX: Column 1: 1 2 3 4 5   I want to be able to have this column automatically update and be created on the second sheet when it is changed on the first. If for example, I were…
    765 8
    765 views 8 comments Most recent by Melissa_
  • ¿Hay manera de distinguir si una fila es subtarea o no?
    In Formulas and Functions
    Quiero que en una columna se muestre un icono sólo si la fila no tiene subtareas ¿es posible con una fórmula? Gracias
    Accepted
    7 2
    Accepted Answer 7 views 2 comments Most recent by Manuel Crespo
  • Populate Column
    In Formulas and Functions
    I have a sheet named GROCERYSTORE and a column named PRODUCE.  I have another sheet named PANTRY and a column named VEGGIES.  I want to reference column PRODUCE so those values are pulled into my VEGGIES column. If I later add a entry to t…
    Answered - Pending Review
    7 2
    Answered - Pending Review 7 views 2 comments Most recent by Melissa_
  • How to keep a cell blank if there is no data?
    In Formulas and Functions
    I have two sheets a master (2800 records) and a feeder (270 records). I am using the following formula to update a column called scheduled date on the master: =INDEX({feeder06262021 Range 1}, MATCH([email protected], {feeder06262021 Range 2}, 0))  Wh…
    Accepted
    9 2
    Accepted Answer 9 views 2 comments Most recent by ed.jaro
  • Combining multiple criterias with countifs and has
    In Formulas and Functions
    I would like to simplify my formula =COUNTIFS({WK 24 Range 1}, HAS("5:00", @cell), {WK 24 Range 2}, "") + COUNTIFS({ WK 24 Range 1}, HAS("5:15", @cell), {WK 24 Range 2}, "") + COUNTIFS(WK 24 Rang…
    Accepted
    12 2
    Accepted Answer 12 views 2 comments Most recent by Mary Kam