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 symbolIn Formulas and FunctionsIn 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 …
-
Auto Delete Data in SmartsheetIn Formulas and FunctionsIs there a setting in Smartsheet that will allow me to auto delete data after 30 days?
-
Lost with vlookup or matching?In Formulas and FunctionsI 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…
-
How to create this COUNTIFS with AND/OR/NOTIn Formulas and FunctionsI 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 <> "…
-
IF Function for multiple valuesIn Formulas and FunctionsCan 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…
-
Linking Two Sheets to update dynamically When columns are added and removed.In Formulas and FunctionsI 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…
-
¿Hay manera de distinguir si una fila es subtarea o no?In Formulas and FunctionsQuiero que en una columna se muestre un icono sólo si la fila no tiene subtareas ¿es posible con una fórmula? Gracias
-
Populate ColumnIn Formulas and FunctionsI 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…
-
How to keep a cell blank if there is no data?In Formulas and FunctionsI 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…
-
Combining multiple criterias with countifs and hasIn Formulas and FunctionsI 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…
