-
Adding # of days with in a date range
this is what i came up with looking at other people i keep getting #invalid operation =SUMIFS({2021 Sioux City Utility OSHA 300 Form Range 18}, {2021 Sioux City Utility OSHA 300 Form Range 1} <= DATE(2021, 1, 31), {2021 Sioux City Utility OSHA 300 Form Range 1}, >=DATE(2021, 1, 1)) the first range (range 18) is the #number…
-
Why are the formula examples from the help section not working in practice?
Hi all, I'm fairly new with smartsheet, and I'm getting errors trying to use the direct help examples they provide for formulas. Does anyone know why, or what I'm doing wrong? I appreciate any insight!
-
(Count if) And & Or
I need a formula that will count the number of rows with High priority and are New OR Open. I cannot figure this out, so any help is appreciated!
-
Nested OR function within and AND logical statement
Hello, I am trying to have the following into a single logic statement: IF Nucleotide Category is "Labeled" AND Characterization Status is "Characterized" AND QC Status is either "Pending" OR "Incomplete" =IF(AND(Nucleotide Category]@row = "labeled", [Characterization Status]@row="Characterized", (OR([QC…
-
Formula for referencing two columns in another sheet.
Hello, I would like to add a formula for the partners' cell(image #1) to reference the two columns in another sheet (image #2). The current formula you see in the first image only references the Partners(existing) column. Any help is deeply appreciated!
-
Countifs after a date
I am trying to count the number of closed opportunities for the 2021 calendar year that meet the criteria of: Won AND is of market sector offices new. I have used the formula below but it's not working. Where have I gone wrong? =COUNTIFS({Sheet - Sales Pipeline Sales Stage}, "Closed Won", {Sheet - Closed Opps Market…
-
Need a formula for Calculating the average for % Complete Column.
-
Tried this one it says UNPARSEABLE??
=INDEX({Description List}, MATCH([Description]@row,{TGS Part Number},0))
-
Missing IF?
I am using the following formula to return the oldest (no of days) unanswered question type of 'alterntaive proposal' =MAX(COLLECT({Days since submission}, {Question Answered}, 0), {Submission}, "alternative proposal") However, it returns the oldest of all question type alterntive proposal so answered and unanswered. makes…
-
Rank Top 20 Clients By Value of Won Opportunities
We have a sheet we use to track opportunities. I'm trying to figure out a formula to create a list of top clients by the value of won opportunities in a metrics sheet so that I can add the list to a dashboard. Above is an example of the data. The list of clients changes so the formula needs to by dynamic. I want to show…