-
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…
-
Sum If
I'm trying to do a sumif calculation that returns the dollar amount that was overpaid. I already did a simple formula of =[Open Balance Amount]@row - [Amount Paid ]@row. I wanted to know if its possible to show as a plus amount vs negative(-) amount
-
From another sheet, how can i lookup / pull a list of values ?
Hello world, I have two data sheets that both have columns that contain a identifier for what the row references. I want to make a list in my third sheet that contains all the identifier values of these two data sheets that meet my criteria of containing letters xx in the end of their identifier names. Is this possible?…