-
Time tracking / Formulas.
Hello, I'm trying to setup the following: • Time tracking spreadsheet with the following columns: Date, Client, Project, Time (increments of .25 hrs) • either in the same sheet or different: Ability to either loop through each row and spit out all projects and time spent during the month. (We Bill each client at the end of…
-
RYG formula with a date reference
Looking for formula help with RYG referencing a date column. I want a green ball if the expiration date is more than a year away, yellow ball for expiration between today and 365 days and red for any date in the past.
-
Auto Checkbox: Only if All Children / Decedents are Checked
Good Day All: I am trying to modify a basic Formula to Auto Checkbox the Parent only if All the Children / Decedents are Checked. =COUNTIFS(DESCENDANTS(), 1) Thanks
-
Limit Results to Specific Year
I have added the number of closed projects to a report by getting the total from the "Status" column in another sheet, like this. =COUNTIF({ARC Range 2}, "Closed") There is also a "Date" column in the sheet. How can I query that column also to limit the report results to just those from 2019?
-
Highlight a date when a date is past due
Hello, I would like the "Bid Back" date to highlight in red if it is past the date in red in the Trade column. I would also like the "Bid Back" date to highlight in Yellow if it is within 3 days of the red date in the trade column. And green if the date is on or before the date in red. Is this possible? Please help!
-
How to use IF(ISBLANK and another IF formula?
Hi, I am using this formula =IF(AND(NOT(ISBLANK([Latest Update]@row)), Level@row = 2), "Update", "") and I would like to add =IF(Level@row = 1, "Project Update") if it is Not Project Update it it needs to be blank. When I put them together I keep getting an error. =IF(AND(NOT(ISBLANK([Latest Update]@row)), Level@row = 2),…
-
If outcome of Formula is 0 show blank
Hi All, I'm using a formula to count how many stores we have opened in a certain country/month. This information is then used in a chart in a dashboard. The problem is that when we haven't opened any store it shows a zero. This zero is also displayed in the chart, and don't want this. So is it possible to make the formula…
-
Counting Children on Multiple Criteria
Hi all I am using the following formula in a parent row which has 10 child rows: =IF(COUNTIF(CHILDREN(), "Complete") < 10, "Not Done", "Done") It shows Done as soon as all the children rows have the word Complete in them. Now I want this formula to favor 2 conditions for "value_if_true" part of the "IF" function: if all…
-
How to use IF(ISBLANK and another IF formula?
Hello, I am trying to create a formula and I need some help. The formula would be in a column which have a single select dropdown option: Update. The formula would use information from two columns. The column names are Level and Latest Update. If the Level = 2, and the Latest Update is not blank, I would like the formula…
-
Sumif (or something similar) using a Multi-Select as a criteria
I am trying to find a way to allow users to select multiple criteria, where each criteria has a score. And once selected, have a column add up the scores for all criteria selected. For Example: Criteria Score Cat 10 Dog 9 Llama 8 Zebra 7 If the animals are in a multi-select drop down, and the user selects Cat, Llama, and…