-
Sumifs multiple criteria single column help
Hello, I'm having trouble creating a formula that will sum if multiple criteria in a single column are met. I want to sum LOE column when the capability = one of 4 values. I'm using the SUMIFS and OR functions to try to make this work in a sheet summary metric but getting the #UNPARSEABLE error. Found a few other posts on…
-
Convert Time/Date to Date Then Convert to Future Date
Data that I'm importing via Data Shuttle includes a date field (named Date Issued) with this format: 2022-01-22T10:30:55.999999889172613350 I added another date field (named Issued Date) where I added this formula to pull out the date only: =IF([Date Issued]@row <> "", MID([Date Issued]@row, 6, 2) + "/" + MID([Date…
-
COUNTIFS always returns 0
I can't get my COUNTIFS equation to work, it always just returns 0, can anybody help? =COUNTIFS([Column A]@row, "None", [Column B]@row, "None", [Column C]@row, "None", [Column D]@row, "None", [Column E]@row, "None", [Column F]@row, "None")
-
Ranking/VLookup Formula with Duplicates
I have an issue with my sheet where we rank the total number of projects closed from 1-5. Rank is in the first column, second column is a formula: =MAX(COLLECT([Total Project Closed]:[Total Project Closed], [Rank for Completion]:[Rank for Completion], [Rank for Sheds Comp]@row)) this returns the number of projects closed.…
-
Need Help with UNPARSABLE ERROR and BLOCKED Formula error
I need a Date (the Actual End Date) in the Description Column Row 35.when the Task cell equals the task of current row. and if no date in that cell to be blank Current formula is =IFERROR(DATEONLY(INDEX(COLLECT([Actual End Date]59:[Actual End Date]354, [Summary Formula Helper]59:[Summary Formula Helper]354, 1,…
-
Struggling with if formula to show overdue task and activate red flags
I have been playing around with the IF formula and thought I finally got the hang of it. However my "overdue" statement is not working and just set's it to "In Progress" when percent complete is not 100% on Todays date. I also want to do an At Risk statement but need to figure out what is wrong with the current formula.…
-
How to search for one value from data available in multiple columns and rows?
So i have one field where i need my team to input purchase order number (Correct PO number (unit team to update)). Once they put it there, i want to put a formula in next column that acts as a validation check to see if the number inserted matches or does not match with purchase order numbers in another sheet. So the…
-
Counting Days Between Two Dates With Weekends, Without Holidays
I am looking for a way to get a count of days between a start date and end date, but I want to include weekends and exclude holidays. Is there a function or combo of functions I could use?
-
Check Parent if All Children are Checked
We use Smartsheet to house our product bill of materials across all projects. I would like to use a formula to populate in the parent row (sub-assembly) that would flip from an unchecked box to a checked box if all the children are checked. This is a parts received column so this would populate a report for our assembly…
-
How do we get our hyperlinks to work properly?
We are currently working on a sheet where if a specific number is entered in a cell, a corresponding hyperlink will be next to it. We have a sheet for hyperlinks and the IDs that are associated with them so that we can use a formula to pull that link when it sees its code. Our issue is that even though our links are…
