-
IF formula: IF x in column A then enter this in this column B
Hello All, Need some assistance with an IF formula. I want to create a formula where each month in a row is accounted for and assigned a Quarter. Q1 ( January, Feb, March), Q2 (April, May, June) Q3 (July, August, Sept) Q4 (October, Nove, Dec). Below is a part of a formula that I have come up with - let me know your…
-
In Progress Formula Not Working (Also Start Date Not Adjusting)
Hello, We had a project template set up for us that would automatically provide a status of "In Progress" if the % Complete was not 0. I made the % Complete 10% for one of the tasks and the parent didn't pick it up, so the status did not move to "In Progress". Here's a screenshot of the task being 10% complete and the…
-
I need help with formulas
I am working on formulas to get approvals in one of my sheets - But there are more than 2 options and I'm finding it a bit confusing… IF both directors APPROVE = Trade Off Accepted IF one director APPROVES and the other one is PENDING = Pending Acceptance (Would I need two of these?) IF both directors REJECT = Trade Off…
-
Parent rolling up data in Children rows
Green line is the parent row everything inbetween is children rows Column 30 is counting rows from N/A column that are not ticked, which are the rows im looking for. so 6 rows are active rows which are being used. out of the 6 rows, 4 rows have been ticked in appoinment concluded column i want to roll up the count of 4 in…
-
COUNTIF FORMULA WITHIN DATE RANGE.
Hi All, I get invalid operation for the following formula. Any ideas on my error? Trying to count the number of times something appears in a column within a date range. Any help would be great please. Thanks. =COUNTIFS({TIME RECORDING}, ([Column7]@row), AND(@cell >= DATE( [Column6]2), @cell <= DATE([Column6]@row)))
-
Formula to Count Ages of Orders
I'm trying to create a formula that counts the open orders based on the date the order was created. The thing complicating the formula is that it's for a metrics dashboard, so I need it to count the orders that are between 1-3 months old, 3-6 months old, 6-9 months old, 9-12 months old and over a year. I'm at a complete…
-
Pulling data from one form to another
I am creating a sheet that will collect data from multiple regions through a specific contact. I currently do it through automation. When I fill in a specific region the email associated with this region is in the automation that I created and it populates the particular cell, and sends a form to that person. I am…
-
COUNTIF and HAS
I'm trying to use Sheet Summary fields to determine how many people have signed up to work a football game. The Sign Up columns are multi-select dropdown, and I feel like I've done this correctly, but it returns the answer of 0, despite my having 2 instances when they should be counted. Any thoughts to remedy?
-
CONTAINS or HAS formula extension
Hi community, I am looking to extend either a CONTAINS or HAS formula to pick up a dropdown value from one column and assign it a numerical value in a separate column. Can anyone assist in what is the most effective way to do so? The intention is when any value from the "Suburb Population" column is selected via dropdown…
-
Need help with conditional formatting
HI, I want to make a conditional formatting rule for IF "ETA" is greater then "TARGET RECEIVE BY DATE", then highlight yellow. The current columns are formatted for TEXT/NUMBER. Not sure if they need to be in DATE format within column properties.
