-
Matching a Name to another sheet and is checking a row if it is a date
=IF(AND(MATCH([Team Member]@row, {Team Member}, 0), ISDATE({L1 Mixer})), 1, "") This is what I try and it returns incorrect argument set on the first row, but invalid data type on the remainder. It is a column formula.
-
INDEX/MATCH with Checkboxes No Results
The formula I'm using isn't giving me an error but for some reason I am not getting any checkbox responses either. The reference sheet for Agreements has an ID I am trying to match to my current sheet. Then if the checkbox for that row is checked, I want this formula to check the box in my current sheet. Without the…
-
Using IF(ISBLANK) formula returns a circular error
I have two columns, both Contact List but not enforced. Requestor Name comes in with a new request from a form and can be an email or contact. Project Owner is not updated for these entries. We also enter rows in different ways, and will assign a Requestor Name from contact list. I'd like to create a formula which copies…
-
If any of the cells being searched are not blank return a 1
=IFERROR(IF(AND(MATCH([Team Member]@row, {Team Member}, 0) > 0, COUNTIFS({Team Member}, [Team Member]@row, {L1 Mixer}, {L2 Mixer}, {L4 Mixer}, {L5 Mixer}, {L6 Mixer}, {L7 Mixer} <> "") > 0), "1", "0"), "Error") It is searching for all of them returning not blank. I am wanting if any of them are returning not blank.
-
Extracting email information from a contact column
I have a need to extract email information from the information in a contact column. My users occasionally need to copy and past email information into other applications. I know that if I reference a contact column into a text column that the name comes over as text. I need a way to do the same thing, but have the email…
-
Formula for Start and End Dates in a column
I'm trying to create a Sheet Summary formula to return the first date in a column and keep getting errors. I can't seem get it to look at the entire column or even a range. I've confirmed the reference columns are all Date columns. Here is the formula I'm attempting and the error I'm receiving.
-
Formula in Smartsheet
Hi I have the formula as below and it working but when i add 1 more status it turn out error =IF(AND([CM attention required]@row = "Yes", [PPV Status]@row = "MSI CM Review"), VLOOKUP(Commodity@row, {Category Managers Range 1}, 3, 0), VLOOKUP(Commodity@row, {Category Managers Range 1}, 2, 0)) Formula below have error since…
-
I am trying to figure out formula using SUMIFS with OR and AND functions inside.....
I was able to get to the below formula - "SUM of {FY23Loan} reference IF {FY23School} reference is either "Doerr School of Sustainability" OR "DOERR" OR "EEES" =SUMIFS({FY23Loan}, {FY23School}, OR(@cell = "Doerr School of Sustainability", @cell = "DOERR", @cell = "EEES", @cell = "ERS")) but then…. I realized I need to add…
-
Joining Child Rows to Parent Row and Line Breaks... Need Bullet
I am trying to get my child rows to roll up to the parent row and have a line break in between each row which I have done, BUTTTT I need each new row to start with a * which I have done, except the very first row. Basically I need it to look like bullet points for all child rows:…
-
IF AND based on an input + or -
I can get this to work and in my head it should :) I want an "In Spec" IF… the Stage 1 Temp Verification is less than or equal to S1 Temp minus 5 AND Stage 1 Temp Verification is great than or equal to S1 Temp plus 5. =If([Stage 1 Temp Verification]@row) <=([S1: Temp]@row + 5), ([Stage 1 Temp Verification]@row) >= ([S1:…