-
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…
-
How to put a value for each item in dropdown list
I have a dropdown list and I want to put a value for each item (but not in the list): Not Ordered = 0% complete Ready to Order = 1% complete Order Process = 20% Shipped = 50% complete In Country Customs = 80% complete Delivered = 100% complete Cancelled = 100% complete This is to help me to calculate the task % complete…
-
Using a Flag column to identify associates that are on another sheet.
Hi, I'd like to create a formula to vlookup a cell value from a separate smarsheet and if that associate is on that sheet, instead of pulling back #NO MATCH, and the cell value if it is on the other sheet, I'd like for it to flag an associate if they are on the list. So I'd like that column in my main sheet to be a flag or…