-
Issue with If Statement
Not sure if it is possible, I have tried some basic if statements but not getting anywhere. Looking for some help please, trying to get an if statement to work in the Validation Status column, where if the due date is over 7 days the status column is populated with 'overdue', or if the due date is within 30 days then the…
-
Return a date from a row, on a different sheet, that corresponds with their name.
I have a sheet that I am trying to inform team members when their license expires and I am wanting a formula that looks at one sheet, if the name is there it return the corresponding value. I can get the formula to return yes or no but I need the exact date. =IFERROR(IF(AND(MATCH($Name@row, {Team Member}, 0) > 0,…
-
Sheet Summary Formula Error due to Formula in Sheet
I'm using Sheet Summaries to total up information in a large sheet. This sheet also uses formulas to pull information from other sheets. I receive a #NO MATCH error when attempting to use a COUNTIF formula in the Sheet Summary on fields that are being pulled from other sheets via formulas. Is there any way around this…
-
Trying to use index collect, vlookup and index to reference two columns on two sheets
I am trying to write a formula based on two sheets. One sheet, Team Members, that has the following columns: Column 1 - Region Column 2 - Industry Column 3 - Contact The other sheet has many columns, but it has matching columns of the same Column 3 - Region Column 4 - Industry Column 10 - Contact I've tried a bunch of…
-
Help identifying duplicates using two columns but excluding entries.
I would like to locate duplicates in my sheet using the name column and email column. Just starting with the name column gets me nowhere. I keep getting #UNPARSEABLE. I am using =IF(COUNTIF(Client Name:Client Name, Client Name@row) > 1, 1) in a separate column. Eventually I would like to include the email column which has…
-
COUNTIFS formula not functioning how I expect
Hello, I am expecting this formula to count the number of cells in the "FND Prepare" column that have a certain name in them, where the cell on the same row in "Prepare Status" is not green. =COUNTIFS([FND Prepare]:[FND Prepare], HAS(@cell, "NAME"), [Prepared Status]:[Prepared Status], (@cell <> "Green")) Does someone have…
-
Translating an Excel Formula to Smartsheet - #UNPARSEABLE
Hello all, I'm attempting to create several self-updating sheets fed by a manually updated database sheet. The goal is that it will feed into the multiple other sheets so that we can then give access to smaller groups of people based on which locations are returned by the reference cells. I've been able to successfully…
-
Index Match Formula Not Working
I have a customer ID table (sheet 1) with two columns, Customer ID and Customer Full Name. On a separate sheet (sheet 2), we have entered customer projects using the same column, "Customer ID". To prevent double entering and typos, I have a column on sheet 2 I have a column for the customer's full name and I use an index…
-
VLOOKUP or Match Formula for cross referencing sheets
I'm trying to create a report that outlines tasks by Department. When we created our project plan sheets, we didn't include a department column and only included an Assigned To column for resources. I do however have an Employee Info sheet that lists all of the employees who can be Assigned To and their corresponding…
-
How do I create one sheet that automatically ingests data from other sheets?
Howdy community! I have about 90 different project plan sheets that there are static cells I'd like to pull information in from. Those I have already created on a different sheet by using a cell reference. Easy enough. My struggle now is there is a separate sheet for all 90 of those projects that contains status updates.…