-
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…
-
Conditional formatting
How to transfer conditional formatting of one table to all existing ones? Can this be done somehow automatically?
-
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…
-
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…
-
Using @row with references to other sheets
I have one sheet that contains a number of calculations and I am trying to use a cell reference in another sheet if a condition occurs. I have the formula correct when all the data is in one sheet, but when i try to pull from another sheet, i am missing something. When in the same sheet, i am using the following formula to…
-
Counting Employees in Assigned To Column
Hello, I can count how many times somebody's name is in the Assigned To Column, but when I have multiple people assigned to one project, my formula does not count either person. Does anybody know what I am missing? Formula is =COUNTIFS({Assigned To}, [Primary Column]@row, {Status}, "Backlog") Thank you, Derek
-
Help with Formulas in Summary Sheets
I am new to formulas and need help with a COUNTIFS formula. I am trying to quantify how many RAID Log items are in a sheet and I tried several combinations but can't seem to find the appropriate formula. See below, what would be the appropriate steps to quantify those items?
-
Date range in formula
Hello! I am trying to write a formula to pick up statuses before a specific date. So I want everthing before 4/1/2021, but nothing after. Here is what I have (I tried to look at others on the message board) but it still isn't correct. How do I fix this? =COUNTIFS({Finish Date}, <=DATE(2021, 1, 4), {Status}, "Not Started")…
-
Can you use Ancestors along with IF(And to check a box?
Hello, I need some help with a formula, if it is even possible. Scenario: Overall Project: checkbox column Exec Report Activity: checkbox column Reporting: checkbox column Is it possible to have a formula search for a checked box in the Overall Project column (Overall Project Check also indicates that it is a parent row)…
-
Percentage Complete
Good afternoon, I am hoping for some guidance on how to set up a percentage complete column to track progress for a specific set of tasks. Thank you, Corey Niro 512-214-2527