Formulas and Functions
Archives for December 2020
Discussion List
-
flag if > 6000In Formulas and Functions=IF([Current Mileage]@row - [Service Mileage / Hrs]@row, >6000, 1) What am I doing wrong? Iwant to flag if the difference is greater than 6,000
-
Count ifIn Formulas and Functions=COUNTIFS({Equipment Inspection Log - Webform Range 4}, "Good", {Equipment Inspection Log - Webform Range 2}, [email protected]) What am I doing wrong? my first range is multiple columns
-
Answered - Pending Review 11 views 1 comment 0 points Most recent by Leibel S Formulas and Functions
-
MAX NUMBER ON A NOTHER SHEETIn Formulas and Functions=IF({Equipment Service Log - Webform Range 2}, [email protected], MAX({Equipment Service Log - Webform Range 1})) Trying to get the max number from another sheet if the description is matching
-
Skip blank cells in a workingdays formulaIn Formulas and FunctionsHello, I am currently using this formula to calculate number of working days. On the same sheet, I have two different processes that I track. Some assets on rows do not complete both processes so there are blank cells. =NETWORKDAYS([MPT …
-
Count for two dates on a summary sheetIn Formulas and FunctionsI am sure that this is a simple question, but I can not figure out how to count two dates on a summary sheet for a dashboard. The date format is M/DD/YY and the dates are in the same column. Thanks in advance for your help!Answered - Pending Review 21 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
pull Value Left 1 position from other smartsheet cellIn Formulas and FunctionsFormula below works, however the "Discovery Receipt" cell on main sheet is a single select drop down: 0 - Bad 1 -Good 2 - Best I only need to sum the left most 1st position. =SUMIFS({Discovery Receipt}, {Date of Presentation}, @…
-
Max Children with Dates or TextIn Formulas and FunctionsHi All I am trying to pull either a max date or text into a parent row and I am getting an #invalid data type error. The column is a date column. If I change it to a text column, I receive #invalid column value. I'm not sure this is the …Answered - Pending Review 23 views 6 comments 0 points Most recent by Kelli.Cook Formulas and Functions
-
Trying to use SUMIFS function to count spend in 2020 by FirmIn Formulas and FunctionsStruggling newbie here! For the life of me, I can not figure this out. I am trying to find the spend of each firm, and qualify it by the year so that once 2021 rolls around, I can track spend-by-year. I know the end of my formula below is…
-
Simpler way to convert High/Medium/Low symbols to score - without using nested IFs?In Formulas and FunctionsI am trying to "score" rows using Impact vs Effort columns. I know I can do this using a complicated nested IF statement. In google sheets, I can more easily use VLookup or Choose like this: =VLOOKUP(M4,{"Low",1;&quo…