-
Countif and HAS for multiselect for Quiz answers
I am using Countif and HAS to count a cell if a person has selected the correct quiz answers in a multiselect field. =COUNTIF([Q2]@row, HAS("a", "b", "c", "e")) This is returning 0 and I am not sure why?
-
Finding the second to last in a collection
Hello - I'm using INDEX to find the value of [Scanned Location] that corresponds to the MAX [ROW#] of a collection that matches my current [Asset ID]. My formula is =INDEX([Scanned Location]:[Scanned Location], MAX(COLLECT([ROW#]:[ROW#], [Asset ID]:[Asset ID], [Asset ID]@row))). Now what I want to do is find the second to…
-
Finding the Percentage from two values
Hi All, Sorry for this very basic question, but I am driving myself nuts trying to find the correct formula. Trying to calculate the total % complete from checked boxes. I have a count for when boxes are checked and a count for the total number of items listed on the sheet. How do I get the % of the checked boxes total?
-
Filter to show only dates from this week???
I'm making a project schedule for our construction company. I would like to be able to have a filter that only shows "Start Date" that is equal to this week or this month. Is that possible?
-
Conditional column formula that updates another column
I am trying to create a condition that if the status column is complete mark % complete column to 100% if in progress mark 50% and if not started 0%. Is there a way to do this?
-
How do I get formulas from a sheet pointing to a template to work when the template is saved as new?
I've got a template built for a repeating project format and I want to be able to roll up key fields from all of the projects into some combined sheets. The formulas work when populating the original project sheet but when I save as a new sheet, the link breaks. This is only a problem in breaking the links going from the…
-
Calculated Column and NETWORKDAY - latency and wrong numbers
Hi, In one of my project, I have a calculated column (Duration) with the formula : =IFERROR(NETWORKDAY([Current Start Date]@row, [Current End Date]@row), 0). When compiling sheets in a report, I saw that the number in the duration column were incorrect. They show the number of calendar days+1. As you can see in the GIF,…
-
Index Match or Max Collect Formula?
I have a form that people can use to submit an "Updated Due Date". This can be Approved or Denied by a supervisor. Once approved it moves to an Approved Sheet with the Move Row automation. Multiple entries can be made for the same project. I have a main sheet that pulls all the data together, and I would like the Updated…
-
How to alert regarding a duplicate value within a row?
Hi I would like to add some sort of alert or conditional formatting, but I'm not sure how to accomplish this. For the columns impacted they are all dropdown single select columns. I want some sort of alert, could be as simple as highlighting the row, if a value in "Faculty on PTO" appears in any other column for that…
-
Summation of costs
Hi all, Disclaimer: SS newbie/teaching myself. I have Control Center provisioning a set of artifacts once a project is approved. Specifically a cost tracking sheet that I'm trying to roll into a Portfolio Summary, and I've hit a wall. I'm trying to roll up all actual costs into the Portfolio Summary in the Actual column.…