-
Countif lookup by email/contact
Hello - I have a sheet ("Sheet 1") where users enter various entries/plans, etc. via a form and to associate it with themselves, I have them use their email address which logs into a contact column. In another sheet ("Sheet 2")- I have a list of everyone who is expected to put in information. I have a contact column with…
-
#INVALID DATA TYPE with a VLOOKUP formula
I need to turn a column of dates into two additional columns, one with the month name and one with the year. The year was easy. But when using the MONTH formula, it returns the month as a number, 1-12. No big deal; as a workaround, I set up a "helper table" in another sheet with the numbers 1-12 and their corresponding…
-
Test against Attachments column within formulas
How would I reference the Attachments column in writing a formula? For instance, if I want one column's text to display "Attached," on the condition that there are attachments to that row? Or if there are better ways to do it that would be great. I have a "Resource Locations" sheet. In each row there will be the name or…
-
Using If/Then Formula
I'm new to Smartsheet and have a drop down menu that needs to tie to another column/field I am trying to create a if/then formula but obviously I'm doing something wrong as I keep getting an #UNPARSEABLE error. I'm trying to say "if Industry Examinations equals Series 24, then add the description, and if not, then leave…
-
Help with #DIVIDE BY ZERO error message
Hello, Hoping you might be able to assist me with a similar issue I'm experiencing. I've attempted to import a Trello board into Smartsheet for one of my colleagues and I'm getting the same error message, when I view it in grid view on some of the rows. The formula in question that is currently being used…
-
Auto Populate
Hello all! I am trying to have a cell auto populate information based upon values in another sheet. For example, in Sheet 1, I have the columns "Customer" and "Notes". In Sheet 2, I have the same columns. I would like to enter a formula in Sheet 1 in the Notes column which would auto populate the notes from Sheet 2 when…
-
Summary by name and date range
I will try to explain the best I can. I don't have the Pivot app, so wondering if there are any other "tricks" that might work besides exporting to Excel. We are using Smartsheet to log everything that goes through our final testing department. So, assembler, qty inspected, qty rejected, date, etc. Is there a way to…
-
AverageIf Statement Not Right
Hello, I am trying to get the average of a column based on the owner. The range is a column with a formula resulting in a number (=[Planned % Complete]@row- [Actual Complete]@row). The criteria is a contact column. My formula is as follows: =AVERAGEIF({What The Frog 1}, CONTAINS("Big Bird", {What The Frog 2})) I have tried…
-
Adding all task participants to parent cell
WHAT I WANT TO DO: I need to add all participants of tasks to the tasks' parent cell (one time each, in case that's an issue). If there is a way to automate this, I would love to hear it. That's the long and short of it. WHY I WANT TO DO THIS: Why do I want to do this? Well, in an attempt to add parent rows to reports, but…
-
INDEX/MATCH Formula
Hello! I'm creating a document where I would like to index a column of dates, and return a specific date from that list. I need one of two things to occur: 1) If a date occurs in the upcoming week, I would like to return the latest date of the week 2) If no date occurs in the upcoming week, I would like to return the…