-
Health and Status roll up from task to child to parent
My roll-up formula in my parent row is working perfectly and captures the information from its primary children rows. =IF(COUNTIFS(CHILDREN(), "Red") > 0, "Red", IF(COUNTIFS(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIFS(CHILDREN(), "Green") = COUNT(CHILDREN()), "Green", IF(COUNTIFS(CHILDREN(), "Blue") =…
-
Formula for checkbox if meets criteria
Hi, I've kind of asked this question before, but the formula that was suggested doesn't work on multiple dates. I have sheet A and Sheet B Sheet A has columns of ID# and Date Sheet B has columns of ID#, Date 1, Date 2, Date 3 etc... The formula I have in sheet B didn't work when there is a different date column in the same…
-
SUMIF
I have a sheet with values, Dates created and Sales Person. There are multiple Sales Persons attached to multiple values and dates created. I have used SUMIF to gather and total the values per month. =SUMIF(Created1:Created211, MONTH(@cell) = 8, [Contract Value]1:[Contract Value]211) How can I also break the values down…
-
Updating "master" task sheet status from six sub-project task sheets
I want to keep task sheets for six projects. I want them to feed to a "master" sheet. I have successfully created the automations to copy tasks as added to the six sheets to the master. Where I am struggling is in updating the master as tasks move from "new" to "in process" to "complete". I don't want to use an automation…
-
SumIf
I am trying to use the SUMIF Formula to reference a sheet to add hours based on the name of an employee. I have a Names Column with a list of names and an Hours Column. On a second sheet I am trying to print out their hours added together based on their name. My attempt =SUMIF ({HoursCol}, Name@row = {NameColum},…
-
Auto-Number Reset
I'm using a custom auto-number field in combination with a Date and a Time fields to create a sort of priority list with which requests are processed. I'm facing a problem with requests that are already in the queue and users go in and and change the Date or Time (this is a valid action) but since the auto-number doesn't…
-
Manpower Counts by Date
Hi! I have a construction schedule with the following column names: task, start date, end date, duration, assigned to, manpower. The "assigned to" column is different subcontractors such as "sheet metal subcontractor", "piping subcontractor" etc. My schedule is about 1500 lines long with lots of concurrent activities. My…
-
Comparison/Highlight help
Hello! Trying to figure out the best way to compare data for some servers. What I want to do is something like: for all rows where [Shortname] is identical, compare [Provisioned Space], [Memory Size], and [CPUs]. If there's a mismatch, highlight the cell. Is something like that even possible? I want to compare prod and uat…
-
Count two different combinations of criteria.
This formula works for one combination of "HWMP" + "Notice Package Approval" =COUNTIFS({Regulations Development Range 5}, CONTAINS("Notice Package Approval", @cell), {Regulations Development Range 3}, "HWMP") I'm trying to expand it to count two combinations: "HWMP" + "Notice Package Approval" "HWMP" + "Pre-Comment Period…
-
Formula to subtract 1 hour from military time
Hello. I have what seems like a simple request yet I can't seem to figure out the formula. I have a column entitled START TIME formatted as hh:mm AM/PM. In a separate cell on the same sheet I want to take that START TIME, convert it to military time, and subtract 1 hour. From a previous thread I found the formula to…
