Formulas and Functions
Archives for October 2019
Discussion List
-
Finding duplicates numbersIn Formulas and FunctionsI have been trying to build a formula that will find duplicate numbers. Most solutions that I found in the community will only work for text. Can anyone help with finding what I'm doing wrong. The formula shown on my screenshot is the same…
-
COUNTIFs for DatesIn Formulas and FunctionsI'd like to create a formula which only counts the Rows in which a date in a particular column is in the last 30 days (among other criteria) =COUNTIFS({Referral Source}, "Elm", {Database Status}, "Green", {Database D…
-
Sumifs Help with Month/Year and checkboxIn Formulas and FunctionsI keep getting an error when writing this formula. Can someone please help? I want to sum the "Weighted Range" when "Prob Closing" is checked (1), and "Close Date" is January (1) of 2020. The 3 columns are …
-
COUNTIF CONTAINS(OR(In Formulas and FunctionsCan anyone help me with a formula for a multi-select column where I am counting the number of occurrences of two of the options? I think it would be a COUNTIFS(CONTAINS(OR( formula, but can't seem to get it to work. Thanks!
-
Is it possible to apply Conditional Formatting with a formula?In Formulas and FunctionsIn Excel we have the ability to use custom formula for conditional formatting, is this possible in SS? Please see screenshot below. I need to compare column values to the value at the top cell. I can do this by adding more columns and…
-
Smartsheet formulasIn Formulas and FunctionsHi, Can anyone suggest me with a formula to carry out the following function: - If RISK(H/M/L) CAT (0,1,2,3) column states "2" then Start on site date column needs to insert a date 12 weeks prior to the design required date…
-
COUNTIF in Sheet SummaryIn Formulas and FunctionsI am using this simple formula in a new field in Sheet Summary & I keep getting an "Unparseable" Error. =COUNTIF(RESPONSIBLE ENTITY:RESPONSIBLE ENTITY, "FIRM")
-
why does smartsheets not Sum Cells with leading zero valuesIn Formulas and FunctionsI am trying to do a =SUMIF into a sheet via cross reference (=SUMIF({Mth/Yr}, ={Prev Yr Mth/Yr}, {DofC NN.NN})) Mth/Yr = 9-2019 Prev Yr Mth/Yr = 9/2019 DofC NN.NN contains rows that have a value with 0.nn (nn = 01 thru 99) The result f…
-
Changing Status to a number in order to chartIn Formulas and FunctionsHello! I am needing to make a widget in a dashboard t show the number of "complete, not started, or in progress" items I have. I know I need to change the status to a number. I have tried to do this with "IF logic but am fai…
-
Retrieve most recent values in multi-select column using formulasIn Formulas and FunctionsI am struggling to get the formulas to retrieve a value in a multi-select cell. For example: Flavor options in multi-select dropdown: Vanilla, Chocolate, Mint Flavor1: Vanilla (row 1) Flavor2: Vanilla, Chocolate (row 2) Flavor3; Vani…