-
Sum if number is positive
Hi, i have YTD row that calculates the sum of all the month values (numbers) from Jan-Dec (each month has a column named Jan, Feb, March etc). However I want to only include months inthe sum when the month value is greater than zero (i.e. is not a negative number) any help would be super-duper appreciated. thanks!
-
Using IF(OR(ISDATE function
Hello, I'm trying to compare the date in the white column against the dates in the 3 blue columns (below). If there is a date listed in at least 1 of the 3 blue columns, and one of those date is less than or equal to the date in the white column, then it will return a "Yes". If not, it returns "No". The dates listed in the…
-
formula work one one sheet but not another
Hello I have a formula =IF(COUNTIF(IndexKey:IndexKey, IndexKey@row > 1), 1, 0) that checks all the indexkeys in the column to see if there are any duplicates. This works perfectly on my tester sheet which is an exact copy of the sheet I want the formula on but for some reason doesn't work on the main sheet and returns 0…
-
CountIFs and Date range formula
Hi, need help with a formula. I am trying to count a type from one column 'Finding Rating' against a date range in another column 'Last Completed'. So far I have tried the following but they have all come up with UNPARSEABLE. FYI Conformance is one of the types that I need to count =COUNTIFS({Finding Rating}, =Conformance,…
-
Is there a way to get the date into metric sheet
I want to copy the preferred delivery date to metric sheet as per today's date Is there a way I can show this dates in metric sheet. I tried Index match formula but its not working in this case as there will more orders for the same product name. Please help me to solve this
-
Looking for a formula that uses status and finish to calculate health.
Hello Smartsheet experts, I am trying to write a formula that accomplishes the following in a health column with the Red, Yellow, Green, and Blue options... Status "Complete" = Green Status "On Hold" = Blue Finish "Blank"(or "") = "Blank"(or "") Status "In Progress" AND Finish is greater than Today, Green Status "In…
-
ISBLANK Formula for Early, On-Time, Late Tasks
Hi there, Thanks in advance for the help. I would love to be able to have the "Completion" column show as blank if the "Target Release" cell is also blank. Here's what I have written now: Somehow I need to be using "ISBLANK" but I am not sure how to nest it. Thanks so much, Ian
-
Calculate new contract amount when change order is approved.
I need a formula that will calculate 'New Contract Total' (Original Contract + Change Order Amount) WHEN Status = Approved.
-
Copy cell value from one column to another
What formula would be best to use, to copy the cell value from the Employee Name column to the blank Name column?
-
Count IF formula that meets multiple criteria.
I am looking to get an accurate count of someone’s workload. I want to count if a specific person’s workload meets multiple stage criterion such as “Execution” and “Planning” The Support Required column is a contact list. The Stage column in a dropdown list. I am pulling this information into a separate sheet hence the {}…