-
Is there a way to COUNTIF checked boxes, but have the formula skip over boxes with an error?
I have successfully implemented a formula in a sheet summary that COUNTIFS checked boxes in a column but because of the nature in which this sheet is being used, some of the checkboxes that I am counting have temporary #NO MATCH errors due to information not yet being available from other sheets which is thus causing the…
-
Vlookup functions not working on a Master Spreadsheet
My colleague and I, who do extensive work on a master spreadsheet that pulls data from many different sheets, are having a lot of trouble with the vlookup function on this particular sheet. We use the vlookup function in multiple different columns on the spreadsheet in question, pulling data from a different source sheet…
-
Weeks to Date Formula- Revision Needed
Hi All, I am currently using the following formula to calculate the weeks until my project delivery date. =INT(([Due Date]@row - TODAY()) /7)) We deliver the project on Tuesday and count that week as week 0. How can I modify this formula so that it reflects the final week as week zero as opposed to the week prior? Any help…
-
Formula Query - Is this possible?
Good morning Smartsheeters, I am using a sheet for my production team to log their hourly product inspections on. Basically, they will complete a form that will then log onto the spreadsheet; this works great. What I would like to do however, is to save the operators time, have the first 2 columns, "part number" and…
-
How to include formula to perform a count from the keyword in the row and update the count?
Hi expert, Not too sure if this is supported within the function. I have a used case below, I need tester to input their test result in name assigned in the column (Col E-G). Once they input the status = "P" or "F", the Column 'Total Pass' and 'Total Fail' will do the count base on the condition keyword P or F in each row…
-
Is there a list of formulas? or samples?
-
If Statement just not working
i'm struggling with the if statement in general. I have the following set up in my sheet Configuration Column - drop down to allow 4 choices (90, 180, 270, 360) Overall Length - needs to take choice from drop down and have a formula apply depending on the answer (formula applied is using a result from another calculated…
-
How do I convert a number range to a text in another column
Hi Looking to convert a number range in a column where a number is greater then 100, return to say text in another column of Project or where less than 100 to say Small Change, any ideas? Thanks
-
Formula Column deleting formula randomly
I have a series of sheet calculating time allocation % in a formula and I set the column as formula column and locked it, after couple days for some reason the formula disappears, the column remains locked but the formula marking on the top of the rows disappears and my calculation also disappears from the whole column.…
-
Hide Divide by Zero Error
Hello, I am having issues with creating the correct formula that calculates the average of the children rows while hiding the divide by zero errors for columns that do not have any data. Could someone please help? I tried the following =IFERROR(AVG(CHILDREN([Column]@row],""))) Thanks so much!