-
Formula that updates Blank cells, ignores data when present
Hello everyone! Stumped trying to figure out a formula for our Pre Task Plan Smartsheet. We have a form submission process that users answer questions for their project. If they answer Yes, then they are asked to provide more information on 2 additional questions. However if they answer No, the other 2 questions are hidden…
-
Can you Index Match different sheets but have it check multiple rows also?
I am trying to Index Match 2 different sheets and it works when I only have one row that matches. I am trying to match the newest row in a series entry. Context: I have different quote numbers for different submissions on the master sheet form but I have another form on the SKU sheet that we use the same Quote number to…
-
Too many Cells referenced when I try to move rows into another sheet
Hi guys, I wanted to move rows into another sheet (around 100 rows). it is said that there are too many cells referenced by formulas in this sheet, which is odd, because the limit for cross-reference is upped to 250,000 last I checked. The total of Cross referenced column is 4, I currently have 912 rows in this sheet, and…
-
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([%…
