-
How to use INDEX, MATCH and MAX to display newest form entry if cells match
Here's the setup Sheet 1 Columns: Created [standard] | Name | Form Entry Sheet 2 Columns: Name | Form Entry Display MATCH Name:Name and take the Form Entry with the most recent Created i.e. the newest entry Ideas?
-
Forumula for trending up/down
Hello, I need a formula to display the trend of a number. As rows (data) comes in the average value of the column changes and as time goes by the values will go down. I need to compare that average value each day. Meaning if today's average is 5.10 and tomorrows average is 5.50, I need to compare those two numbers to…
-
How to ignore, or return a 0 with a blank cell in an IF formula
Hello! I'm trying to calculate my savings year-to-date. I thought i had the formula, but soon realized that having blank dates (maybe we don't have a start selling date, or the project is still in development), it'll still return a value when it should really be $0. I have no doubt there is a more elegant way to do my…
-
Counting multi select column that is also contact list
I have Contact list - multiple resources can be assigned task I want to count the number of times a particular resource has been assigned a task. I've tried these both: =COUNTIF({Staff Actions Range 4}, HAS("Joe X", {Staff Actions Range 4})) =COUNTIF({Staff Actions Range 4}, CONTAINS("Joe X", {Staff Actions Range 4})) Both…
-
Combining Two Formulas in One Cell (NETDAYS and Addition)
Hi everyone, I am looking to combine two formulas in one cell (one to calculate number of days; one to calculate completion date, using calculated days). The information below was provided to me by my supervisor to use, but I have been struggling to come up with a solution. Here is the information: Formula: First Product…
-
How to change status based on start/end dates/if completed was checked or not.
Hi there, I've been reviewing past topics but haven't been able to get those formulas to work. I have a sheet where there are start/end dates, and a completed check box column. I'm having trouble figuring out how to create a formula where if start date is in the past and end date is in the future, having it automatically…
-
I want to do a serial IF this then that formula across more than one column. Please help!
My =IF(Child@row="Name1", "Parent1") and it worked to bring the Parent name into the @row, but I am trying to also add a few other Child/Parent combos into it as well. For example, In the Parent Column, I want to combine =IF(Child@row="Name1", "Parent1"), OR =IF(Child@row="Name2", "Parent2"), OR =IF(Child@row="Name3",…
-
Need to tweak Health Indicator formula based on "status date"
I need to tweak the following formula to use a [Status Date] instead of "Today". We publish status reports each Wednesday as of Friday of the previous week. I have added a Status Date column that I will update each week to reflect the status date. Current formula; =IF([% Complete]@row = 1, "Blue", IF([Planned Duration]@row…
-
Date formula help: return 90 days earlier than start date, on the closest Tuesday
Hello, I'm looking for a formula to pull a date that is 90 days earlier than our start date but on the closest Tuesday. Thank you
-
IF Statement - Checkboxes
Hi there, I currently have this formula (below) for my checkboxes that states if the end date is less than 30 days away and the Status of a project is "In Progress" the checkbox is checked off. Currently, if the End Date field is left blank and the Status is "In Progress" the checkbox is marked off. I want to make it so if…