-
looking to return the next Monday + 1 week from a date
This discussion was created from comments split from: Formula to calculate the Monday after a date.
-
Formula to return data based on text in another field (same row) but different sheet
Hi, Is it possible to write a formula to recognize specific data from a text field and return data from another field in that same row but in a different sheet? For example, I am putting together a dashboard to display the health, trend and status of the 6 top summary tasks in my schedule. I'd like a formula that would…
-
Joining multiple values into one cell
Hello I'm stumped on what formula I need to use to replicate the below. I have an intake sheet where Users select a 'Service' by way of a checkbox (Development, Digital, Film). I want to be able to join the values which have been checked in the 'Services' column/row but as a column formula. Any ideas? Many thanks in…
-
Countifs with multiple criteria along with a date range.
Hi, I am trying to pull specific data from my sheet along with a date range and the formula works fine up until I put in the date. This is what I am currently using: =COUNTIFS([NOW Case Details]:[NOW Case Details], "Meeting SAP Ariba Standard", Portfolio:Portfolio, "Business Network", Pod:Pod, "Seller Apps", AND([Today's…
-
VLookup with multiple references in one cell
Hey all, I'm not even sure what I'm after is possible, but thought I'd ask anyway. We're using a sheet to track users while they are out on test rides. Each model available for test rides has a number assigned to it. When users take a ride, we enter their name and the test ride ID# to identify who is on which (TRACKER). I…
-
Match all columns to complete
I have several columns with dropdown (Complete-Go, Incomplete, TM Approved-Go) and one column that says (Go/No Go). If all columns have "Complete-Go or TM Approved-Go" the column (Go/ No Go) should be "Go" If any column has "Incomplete" the column (Go/no Go) should be "No Go" I appreciate your help very much! Rob
-
Getting "Unparseable" when adding a new factor to equation
I am trying to have my "status" column populate with "In Progress", "At Risk", "Late", "Complete" and "Not Started" based on the percent complete and the end date. I can get the first four to work but when I put in "Not Started" to equal the percent complete when it is empty, I get an error. Can anyone help? =IF([%…
-
How do you set a flag based on status and days within a due date?
I'm trying to create a formula with the following logic: Don't highlight the red flag if the status is N/A or Completed Highlight the red flag If the status is In Progress or Not Started and the due date is <= Today (-3 days) Below is what I'm using, but now none of the flags are turning red (and no error message appears):…
-
COUNTIFS AND HAS functions for Multiple values
Hello, Need help on this, I need to get the total number per tasks and status in Summary Sheet, resource is Sample Data. Tasks, Assigned Office, Assigned Field (in Sample Data sheet) has multiple values Thank you!
-
Why is my Index Collect formula not working?
My source sheet contains information associated with clients, including site locations, managers, addresses, email, and phone numbers. My destination sheet includes rows with that site information. In some cases, a client has multiple sites. To capture all of the sites (rows) associated with a particular client, I added a…