-
At Risk Flags
How do I format my At Risk column so the flags only appear in the "children" rows, as shown in the screenshot?
-
System Column - Last Modified
Hi everyone! Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified" Here's the problem: If someone only "views" the sheet & doesn't make any updates, every single row in the…
-
Multi-Select
I have a column that has approx 20 multi-select options. I am wanting to run a report that shows a count of any instance in the sheet where let's say HSW has been selected. Column is annotated as a multi-select column/field. Column name Allegation I have tried to run a formula fr count if - but it only picks up the number…
-
Count # of rows of text in a cell
Is there a way to count the number of rows of text within a cell? I know this will change dependent on column width but if I keep my column width static, I need to know how many rows of text I have within a cell.
-
Assign a value based on a date range
Hi everyone, Fairly newish user when it comes to formulas here; please forgive me if this has been answered elsewhere and I missed it in my searching. I'm wanting to assign a value to a column named Bucket based on the value in the Start column for any given task. The date ranges look like this (using a numbered list for…
-
Formulas =SUMIF
Hi, I need help to solve this puzzle. I'm using this sumif formula =SUMIF({Supplier Invoice register Order Number}, [PO Main Contract]10, {Supplier Invoice register value}) to sum up the total value of invoices against a particular order number. I've checked that all columns are formatted as text. See snap shot of actual…
-
Formula to count cells in a column if box is checked
I'm attempting to create a formula that will count the number of cells in a column from range in another sheet, that only includes the cells with a checked box. In other words, there are two columns to include in the count from my Communication Tracker sheet: Done -- checkbox column and Department -- dropdown column with…
-
Getting information from the latest line entry based on date
Hi, I'm setting up a page where you enter 5S audit test data from a Form. It puts a new row in every time with the 5 different 5S scores each in it's own column. We need to find a way to pull the data from the most recent new row. I need a way of identifying the row with the most recent date and then moving across X many…
-
Select a user defined value for a default in a form
Hi, I have an inventory sheet where users are putting products in a box, the user would like to minimize the number of clicks as they are moving large number of products a day but these products will go into several boxes. is there a way to have a form look at a value the user maintained in a table, (box number), then have…
-
Do not want Cells with "N/A" figured in my formula
=SUM(CHILDREN()) / (COUNT(CHILDREN()) + COUNTIF(CHILDREN(), "")) I am using the above formula for percent complete in my project plan as seen by my picture. My question is when certain parts of the project have not been started yet how do you exclude the cell with the "N/A" value in it from being calculated?