-
Summaries in Reports
Hi, This has probably been asked numerous times but I just can't find the answer but I can't believe it isn't possible. I am making a simple equipment inventory with servicing data within it. The services are carried out on a 1,2 or 3 year rolling cycle, so I want to be able to print off a report at the start of each year…
-
COUNTIFS to find unique values across two multi select dropdown columns?
Hi all, I'm looking for some help with a formula that will do the following (see screenshot): for every different "Person x" that appears in the Names column (multi select dropdown), count the total number of unique items that appear on rows wherever Person x is listed. Items are in another multi select dropdown column.…
-
Countif formula
I would like to count the number of children cells that contain dates in February or March 2016. How do a formalize the criterion to select cells with dates in February 2016 and March 2016?
-
Create a Cell that can summarize what's missing in other cells of the same line?
Hi! Sorry in advance, I may over-write / overexplain because 1. I'm lame at explaining and 2. English is not my first language ^^' In my work, I need to do a release checklist, with multiple checks. Each check is a cell saying for example "Date OK?", or "Price in database?" etc etc. I fill this cell with "OK" if it's done,…
-
Nested IF with Children
Greetings, I'm attempting to configure an Epic (parent) field to automatically change based on the statuses of the child fields. For example, the criteria I'm attempting to meet is: If all child status fields are in "To Do" then parent field status is "To Do" else "In Progress" If all child status fields are in "Done" Then…
-
Bold a row if name matches name from other sheet
Hello, I have two sheets. Sheet 1 has a list of organizations and I need to check a box if they have received funding from us. Sheet 2 has a list of organizations we have funded in the past. There are over 100 organizations. What would the formula be to say if the organization name on Sheet 1 appears on Sheet 2 check the…
-
Sum cell from last row - multiple sheets
Hello. Looking to sum a specific cells from multiple sheets. Have 5 sheets. Columns are the same across all five sheets. Looking to take the last entry, say for column 1, across all five sheets and sum those values. That value would live in another sheet. Any ideas? Thanks Shawn
-
VLookup with IF statement
I am going to try the out of spec condition using VLookup. I am not sure this is possible. But here we go. This log has entries that will VARY but do have upper and lower limit specs. However, in the same stage one substrate may have a different u/l spec sujch as seen here with CRS UPPER limit of 175 and all others have…
-
Common status: Parent/Children formula
I need a formula in a parent row to return the most common value of its children: If there are equal or more reds than yellows or greens, the parent status should be red. If there are equal or more yellows than reds or greens, the parent status should be yellow. If there are equal or more greens than reds or yellows, the…
-
Nested IF formula
I am attempting to count cells that have text or not and using this formula: =IF(SUM(IF(SUM((IF(ISBLANK([T2 Last Name]@row), 0, 1) + IF(ISBLANK([T3 Last Name]@row), 0, 1)) + IF(ISBLANK([T4 Last Name]@row), 0, 1))) + (IF(ISTEXT([Last Name]@row), 1, 0))), 0, "") If the cell has text I want it to count 1 - if not then 0 and…
