-
pulling data from multiple columns at once
I have a master equipment sheet with different projects on it. I'm using a form to collect the information from the lightest orange fields because it's the easiest option for my auditors to use when they're in the field. I would like to get that information back to the original sheet. I know I can use an INDEX/MATCH…
-
Returning a value based on one or more of 3 critieria
Hi, I am trying to setup a formula that will return a product description if the entered value matches one of three values. The inventory system we have uses tolling numbers, as well as bulk and final good numbers for identification. Here is an example of the sheet I would be pulling the description from: As long as the…
-
Which is the most efficient formula in this case with multiple conditions?
I want to set up a formula that reflects Status in the Parent row. Below are the conditions: If all CHILDREN tasks are Not Started, then PARENT status is Not Started If any CHILDREN task is In Progress or Completed, then PARENT status is In Progress If all CHILDREN tasks are Completed, then PARENT status is Completed I…
-
Help with IF/Then statement for values between 2 numbers
I manage a sheet where we track Inspection reports and compliance statistics for meeting 24 hour deadlines. I calculate regular submission turn-around time by date submitted - report day. Problem is, that doesn't work for my night shift inspectors because their shift ends on the next day, so they always appear a day…
-
warnings, when a reference, cell link or formula get corrupt
Hi, I was wondering if it is possible to get warnings, when a reference, cell link or formula get corrupt?
-
Indexing Question
Need help with a formula that will hopefully eliminate the need for an additional "helper column". We have built an API that pulls various information regarding our 700+ Pharmacies from our data base into a Pharmacy Site Information (API) Sheet. We use INDEX/MATCH frequently to pull in various fields. My current problem is…
-
I need help with If formula
Hi there Im pretty new to smartsheet and trying to get a stsus column to return a symbol value based upon date and progress column I'm tyring to get the following IF date is in thepast and progress is nt 100% = RED IF Progress is 100% = GREEN IF date is future and progress is not 0% = YELLOW IF date is today and progress…
-
Formula - Check box if all three criteria match
Hello, I have 2 sheets: Sheet 1: list of videos Sheet 2: list of products I want to put a check in the cell for all rows on sheet two where the Title, Edition, and Author match from sheet 1. Here's the formula I am attempting to use: =IF(Title@row = INDEX({Titles with FX Product Videos Title}, MATCH(Edition@row, {PDP Video…
-
Help with COUNTIFS and CHILDREN Function
Hello! I am trying to get a formula to, automatically update status colors for the child and parent. The Parent is distinguished by "Main Project" in the "Project or Task" Column. I would like the Parent Row to update to show the worst status that aligns to the children status (i.e. if all children are green, parent is…
-
How to look across columns with checkbox data type to make them mutually exclusive?
I have 3 columns in my Project Plan that I am using to have team members fill in to indicate if their task is off track, on track, or complete. I only want them to be able to check one of the boxes. Is there a way to look across these 3 columns in a row to meet the following conditions: If Off track is checked, clear…
