-
flag if > 6000
=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 if
=COUNTIFS({Equipment Inspection Log - Webform Range 4}, "Good", {Equipment Inspection Log - Webform Range 2}, Description@row) What am I doing wrong? my first range is multiple columns
-
Flag a date
How do I say =if the date is 30 days in the past = flag
-
MAX NUMBER ON A NOTHER SHEET
=IF({Equipment Service Log - Webform Range 2}, Description@row, 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 formula
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 Start Date]@row, [MPT Due Date]@row) How do I tell the formula if the start and end…
-
Count for two dates on a summary sheet
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!
-
pull Value Left 1 position from other smartsheet cell
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}, @cell >= DATE(2020, 9, 1), {Date of Presentation}, @cell <= DATE(2020, 9, 30), {Status},…
-
Max Children with Dates or Text
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 correct formula. I am using =OR("TBD", MAX(CHILDREN()). Any ideas?
-
Trying to use SUMIFS function to count spend in 2020 by Firm
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 wrong, but I cannot figure out how to qualify by formula by year. I've mastered the…
-
Simpler way to convert High/Medium/Low symbols to score - without using nested IFs?
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;"Medium",2;"High",2},2,FALSE) / VLOOKUP(N4,{"Low",1;"Medium",2;"High",2},2,FALSE) or…