Formulas and Functions
Archives for October 2019
Discussion List
-
First post 10/31/19,Last post 12/20/19I 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…Formulas and Functions736CliffG -
First post 10/31/19,Last post 11/06/19I'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…Formulas and Functions273KMan1190
-
First post 10/31/19,Last post 11/06/19I 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 …Formulas and Functions146JNull
-
First post 10/31/19,Last post 11/05/19Can 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!Formulas and Functions2932kim.wade56346
-
First post 10/31/19,Last post 10/31/19In 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 Functions371pbfalk
-
First post 10/31/19,Last post 11/22/19Hi, 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…Formulas and Functions119sahilhq
-
First post 10/31/19,Last post 03/10/20I am using this simple formula in a new field in Sheet Summary & I keep getting an "Unparseable" Error. =COUNTIF(RESPONSIBLE ENTITY:RESPONSIBLE ENTITY, "FIRM")Formulas and Functions389Donni Matthew
-
First post 10/31/19,Last post 11/01/19I 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…Formulas and Functions435bday2329
-
First post 10/31/19,Last post 11/01/19Hello! 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…Formulas and Functions117nbannwart10
-
First post 10/30/19,Last post 10/31/19I 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…Formulas and Functions381sanjayb
-
First post 10/30/19,Last post 11/02/19I have a dashboard chart widget that was pulling data from a single select option. I've now changed it to multi-select but I see that my chart isn't pulling in that item at all when there are more than 1 item selected. Am I missing somethi…Formulas and Functions494Samira
-
First post 10/30/19,Last post 10/31/19Hello - I am trying to figure out if there is a way to automate the selection of one of three stages (Not Started, In Progress, Completed) based on Start and Due date columns. Activities with a Start Date in the future would be 'Not Sta…Formulas and Functions258Andrea Mayer -
First post 10/30/19,Last post 11/05/19I have been trying to use the Index & Match function to automatically populate in the Parent row based on the status of a Child row, however, the formula will not pick up the Child status. For example, I want the STATUS column of the …Formulas and Functions623rstrecker
-
First post 10/30/19,Last post 11/20/19My organization recently moved from Google sheets to Smartsheet. We were tracking the number of jobs completed by each team member in the last week. We had multiple groups of jobs that would be uploaded as a new tab on the sheet. The repor…Formulas and Functions977Nolan Nordlund
-
First post 10/30/19,Last post 10/31/19Is there a way I can give a date range in the formula below so that it averages between dates 8/21/19 - 10/29/19 =AVG(COLLECT({Nexus Dependencies Range 5}, {Nexus Dependencies Range 1}, "The Scrum Lords", {Nexus Dependencies Ran…Formulas and Functions403sonam.bang
-
First post 10/30/19,Last post 10/30/19Can anyone provide a formula that calculates when an employee turns 18, based on a DOB (date of birth) cell. I've reviewed the forum and found formulas that return an age, but we need a date so we can set up a notifier email to alert payr…Formulas and Functions131Brian_C
-
First post 10/30/19,Last post 10/30/19I'm having issues with making this formula work for the RYGB Balls. Any glaring mistakes? -Green – An open request that was received 1-5 days ago. -Yellow – An open request that was received 6-10 days ago. -Red – An open request th…Formulas and Functions123Rebecca Wilhelm
-
First post 10/30/19,Last post 10/31/19I am trying to set up a formula to allow for conditional formatting but having some problems. This is the formula I'm trying: =IF([Actual]19 >= [Target]19, IF([Actual]19 < SUM([Target]19 * 0.1), IF([Actual]19 > SUM([Target]19 *…Formulas and Functions134Faz Mussa
-
First post 10/30/19,Last post 11/04/19Hi, I have a Form/Dashboard on Smartsheet to book site induction on the project I am currently working on (see attached image). Just like every other Smartsheet forms, once the form is filled in it feeds into the sheet. Is it possible…Formulas and Functions285sahilhq
-
First post 10/30/19,Last post 10/30/19Hello everyone, I created a checkbox column with 3 cells set to toggle on and off conditional formatting rules. My idea is to paint certain cells if certain conditions are met AND one of the 3 cells is checked. I'm doing this mainly fo…Formulas and Functions3048mavalos
-
First post 10/29/19,Last post 10/30/19Hi I'm trying to auto calculate the date. I was wondering if someone could assist. I'm not quite sure how to do it I believe it should be an if statement but I'm not sure how to write it. I have a column that is Date of Last Correspondenc…Formulas and Functions141kari1282
-
First post 10/29/19,Last post 10/29/19Hey guys, I've been unable to find a solution for this one. I have a sheet from which I "VLOOKUP" values from another sheet. This another sheet gets its values from a FORM input. When I reference another sheet as a lookup_tabl…Formulas and Functions805Martin Knor
-
First post 10/29/19,Last post 10/30/19I have a team task list sheet that has a drop-down Status column including Not Started, In Progress, Urgent, On Hold and Completed and we use card view for this. I have a % Complete column that is a text/number field and a Progress symbol …Formulas and Functions533Heather K
-
First post 10/29/19,Last post 10/30/19hi, I am using a lookup formula to find prices for specific things. once a form is used and new information is inputted into the top row the formula says unparseable and the [column name]1 changes to [column name]2. I would like to sta…Formulas and Functions245Cwall052
-
First post 10/29/19,Last post 11/14/19Hello I am looking for a formula that will tell me how many times a certain criteria comes up per month. We have a quote log that has different stages and we need to know how many of each type of quote stage exist per each month. In …Formulas and Functions1713NLegresley
-
First post 10/29/19,Last post 10/29/19I can't seem to get the right formula together in my Active Projects Master Schedule to show the Delta/Slippage in the construction schedules. I have individual columns for Original Finish (Date), Current Projected Finish (Date), and Chan…Formulas and Functions404NBauer
-
First post 10/29/19,Last post 11/06/19Hello, I have a master vendor list sheet that contains a checkbox column for vendor type. I would like to create a new sheet that pulls over just the vendors that have the vendor type column checked. I need a separate sheet so I can use…Formulas and Functions296MJeffers
-
First post 10/29/19,Last post 11/13/19Hi, Due to the limited restraints on the # of rows (5,000) in Smartsheet - I need to create a formula that references multiple sheets for a match statement. See below: =IFERROR(IF(MATCH(([Employee ID]1 + [Current Position]1 + [Training …Formulas and Functions336xnickeddlemanx
-
First post 10/28/19,Last post 10/29/19Help! I need to create a formula to display a Budget amount for a particular team. The Team column is a Count Column, while the Budget column would be a sum. Can i do this? (eg: i want to know the budget # associated with a function le…Formulas and Functions124Sarah_Michael
-
First post 10/28/19,Last post 10/29/19Hello - I am displaying some information regarding things that are approved, in queue or denied. But I am needing to only count parent rows and not the children for them. So the data collected are just for the overall brand and not sub-…Formulas and Functions752mmurray109161
