-
How to count multiple values in a cell within a range?
I am trying to figure out a formula where I can count 1 row more than once in a COUNTIF formula based on what it contains. For example, I have a column that includes multiple values, separated by commas. I'd like to be able to count the total number of commas within that cell. For example, if a cell has three commas - it…
-
Asset Management - Best Practice
Hello Smart People - I’m building a simple asset management solution. I want to track assets as they move between locations using barcode scans only. I have a “live” sheet that has the current locations, updated as each asset is scanned into a new location. Each asset is only listed once here. I then have an “archive”…
-
How to set the start date on a given day of week after predecessor completes
If I have a task that can only happen on a Tuesday (e.g. that's when an approval committee meets), and all the predecessors are scheduled to complete the previous Thursday, how do I schedule the task to start on the first Tuesday after the predecessor completes?
-
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,…