-
I want to know how many rows have changed in the last 30days from a table.
So I have a sheet that is been updated. I would like to write a formula that shows if a particular column changed in the last 30days/ 60 days? Does anyone know to write this formula? Thank you
-
Index & Collect Using Date Range
Hello, I'm trying to return cell values from another sheet based on a date range in a date field but I can't seem to get the formula to work. In a new sheet, I want to return the value of a specific cell from a different sheet based on the date range (3 months prior to today) field. This is what I tried and it doesn't seem…
-
Calculated Status Indicator using task duration
Hi, I need to convert a formula that I used in MS Project (see below) to calculate task health status that uses the task duration. Has anyone created a similar formula that they could share? Purpose: Highlight tasks that are running late, based on the actual % complete compared to the “expected completion” using the task…
-
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?