Formulas and Functions

Discussion List

• flag if > 6000

  In 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

  Samuel Dowdy Jr.

  12/31/20

  Accepted

  31 1

  Answered ✓ 31 views 1 comment 0 points Most recent by Mark Cronk 12/31/20Formulas and Functions
• Count if

  In 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

  Samuel Dowdy Jr.

  12/31/20

  Accepted

  13 8

  Answered ✓ 13 views 8 comments 0 points Most recent by Paul Newcome 12/31/20Formulas and Functions
• Flag a date

  In Formulas and Functions

  How do I say =if the date is 30 days in the past = flag

  Samuel Dowdy Jr.

  12/31/20

  Answered - Pending Review

  13 1

  Answered - Pending Review 13 views 1 comment 0 points Most recent by Leibel Shuchat 12/31/20Formulas and Functions
• MAX NUMBER ON A NOTHER SHEET

  In 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

  Samuel Dowdy Jr.

  12/31/20

  Accepted

  2 6

  Answered ✓ 2 views 6 comments 0 points Most recent by Leibel Shuchat 12/31/20Formulas and Functions
• Skip blank cells in a workingdays formula

  In Formulas and Functions

  Hello, 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 …

  Tbech

  12/31/20

  Answered - Pending Review

  24 2

  Answered - Pending Review 24 views 2 comments 0 points Most recent by Tbech 12/31/20Formulas and Functions
• Count for two dates on a summary sheet

  In Formulas and Functions

  I 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!

  Leni Burrow

  12/31/20

  Answered - Pending Review

  21 1

  Answered - Pending Review 21 views 1 comment 0 points Most recent by Paul Newcome 12/31/20Formulas and Functions
• pull Value Left 1 position from other smartsheet cell

  In Formulas and Functions

  Formula 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}, @…

  Richard Zombek

  12/31/20

  Accepted

  44 3

  Answered ✓ 44 views 3 comments 0 points Most recent by Richard Zombek 12/31/20Formulas and Functions
• Max Children with Dates or Text

  In Formulas and Functions

  Hi 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 …

  Kelli.Cook

  01/11/21

  Answered - Pending Review

  46 6

  Answered - Pending Review 46 views 6 comments 0 points Most recent by Kelli.Cook 01/11/21Formulas and Functions
• Trying to use SUMIFS function to count spend in 2020 by Firm

  In Formulas and Functions

  Struggling 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…

  Sam Clapp

  12/31/20

  Accepted

  12 3

  Answered ✓ 12 views 3 comments 0 points Most recent by Paul Newcome 12/31/20Formulas and Functions
• Simpler way to convert High/Medium/Low symbols to score - without using nested IFs?

  In Formulas and Functions

  I 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…

  Mike.A

  12/31/20

  Accepted

  196 4

  Answered ✓ 196 views 4 comments 0 points Most recent by Mike.A 12/31/20Formulas and Functions