-
Finding duplicates numbers
I 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 the entire column. Cells highlighted yellow should show as a duplicate.
-
COUNTIFs for Dates
I'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 Date of Referral}, <TODAY(-30)) The section in Italics is the area I am trying to sort out. Thanks in advance…
-
Sumifs Help with Month/Year and checkbox
I 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 in another spreadsheet. =IFERROR(SUMIFS({Weighted Range}; {Prob Closing}, 1; {Close Date}; MONTH(@cell) = 1; {Close…
-
COUNTIF CONTAINS(OR(
Can 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 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 formulas and then hide them, it would be cleaner if I can do with conditional formatting.…
-
Smartsheet formulas
Hi, 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. If RISK(H/M/L) CAT (0,1,2,3) column states "1", then Start on site date column needs to insert a…
-
COUNTIF in Sheet Summary
I 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 values
I 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 from the SUMIF is 0 (zero) Does SS not add values with leading zeros? What am I doing…
-
Changing Status to a number in order to chart
Hello! 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 failing. Can someone help with a formula for the following case? If status is Not Started = 1 If status…
-
Retrieve most recent values in multi-select column using formulas
I 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; Vanilla, Chocolate, Mint (row 3) In a separate column I want to use a formula to retrieve the…