-
Detecting Sum formula "null" value
Hi Community I have a simple sheet with a mixture of parent and child rows. Not all parent rows have child rows. I have a very simple formula [=SUM(CHILDREN())] to sum the value of child rows for a parent row where they exist. Where there are no child rows the formula returns a "0". I use conditional formatting to change…
-
How to graph a range of dates when only given a start and finish
I have a sheet where I have individual tasks each with their own start and finish dates that can overlap. They each have a certain # of people assigned to the tasks per day. Essentially, it looks like start: 5/15/23 | end: 6/25/23 | #ofPPL/Day: 5 and for each day in between those dates there will be 5 people. The goal is…
-
Conditional Formatting Affects Hyperlinks
Currently when using conditional formatting hyperlinks are not affected. It would look better if the hyperlinks are affected by the conditional formatting (for example greyed out when box is checked).
-
Hyperlink in Cell Isn't Greyed Out When Checkbox is Selected
I have a conditional format setup on my sheet to grey out a row when the checkbox for row is checked. However, the link that I have setup in one of my cells doesn't grey out. Is there a setting I'm missing for this?
-
Uncheck Box
I have a formula that says IF(Date@row<TODAY(-14),1,0), to add a checkmark, but how do I add a formula that says once a next recurring date has been added to remove this checkmark.
-
Conditional formatting of "start date" vs. "actual start date"
Hi, I have columns for "start date" and "actual start date". If I manually enter an actual start date and it's PAST the proposed start date, I would like that row to have red font. I can't see a way to do this. Using any date column it seems the only option is to use an actual date in conditional formatting. Any…
-
Conditional Formatting
I cannot understand what I'm doing wrong - I have two columns titled 'Owner First Name' and 'Owner Last Name'. There is a third titled 'Registration Type' I have conditional formatting setup that if the cell is blank to turn it red. I added another condition that if the Registration Type is 'Partnership' to ignore and to…
-
How do I update the Parent Cell so that anytime one of the candidates (listed in the Child Cells)...
is marked as "Hired" as the Status, it then doesn't count that row? For reference, see the first Parent Column "Accounting - 3 Openings" - however, there is only 1 opening that doesn't have the status as hired and it's not showing that...I tried to add conditional formatting to change the row to "Green" if status is Hired…
-
What's the best way to get a total count and also categorize the results?
I'm creating a dashboard for our team on submitted tickets but the requestor wants this data to show total ticket amount per team member and also have it broke down into completion dates. Ex: Jane Doe: Total Tickets 100 Completed 1 day or less - 50 Completed in 2 days - 25 Completed in 3 or more - 50 I'm pulling this data…
-
Dropdown list Default value
Hello, I have a dropdown list of 10 values, simply a Right First Time stat tracker. So they choose "yes" if the action on the line was done correctly, or choose one of the other 9 reasons on why it was not done correctly. Is there a way i can set the dropdown list to select "yes" as the default value? Thanks Andrew