-
Is there a way to get two return values in an IF function?
For example, We have a drop column where the choices are home, office, or either... we would like if they chose the either option that values from two columns show up. We currently have this formula which is working fine to return just ONE answer... we would like the last IF HAS function to return both personal and…
-
how can i match e-mails that are the same in different sheets but have different names, for example
sheet 1, e-mail stated John Do, John.do@smartsheet.com sheet 2, e-mail states Do John, john.do@smartsheet.com Even though the e-mail address is the same I can not find them using vlookup, I get a No match error, this is caused by the fact that the names do not match. I don't understand why the name is taken in…
-
Seeking column schedule health formula
I'm looking for a single formula to put into a column that looks at task level performance (assigns RAG based on status - not started, in progress, complete - vs. end date) and also incorporates parent level formula to assign appropriate RAG at the parent level based on status of child tasks - may have multiple parent…
-
Ignore Blanks When Using Char(10)
Hello, I am having display issues when using Join Collect and Char(10). =JOIN(COLLECT([Helper Site 1]@row + CHAR(10) + [Helper Site 2]@row + CHAR(10) + [Helper Site 3]@row + CHAR(10) + [Helper Site 4]@row + CHAR(10), [Helper Site 1]@row + CHAR(10) + [Helper Site 2]@row + CHAR(10) + [Helper Site 3]@row + CHAR(10) + [Helper…
-
SUMIFS question
Hi, I'm trying to return a sum based on 2 criteria's. The state of origin and the type. Not sure how to make it pull the $ or return 0 if its blank. =SUMIFS({1-Filing Status -State}, =State@row, {1-Filing Status-Type}, ="Form", {1-Filing Status -Fees}, 1, 0)) Thank you!!
-
Formula for distinct or unique totals based on multiple criterias
I am creating a table to collect total REPORT KEYS that are unique month to month for each dept, each division and with unknown total transactions in each report key (we don't need to know how many transactions in each REPORT KEY). The data set can include up to 100 REPORT KEYS with no set amount of transactions for each.…
-
Can someone help me with a formula that substract time? Thanks in advance!
-
Vlookup from another sheet
I need to create a vlookup formula that tallies up the total number of times a certain value shows up in a chart under someones specific name from a separate sheet. Right now the formula is giving me a value but it is a random name from 1 column. This is the chart that I am referencing: For example I am needing my vlookup…
-
Formula Question - Blank Needed for a Write-in Value
Hi All, I'm trying to write a formula that will return a blank value (or empty cell) that I can add a "write-in" value - which will be different each time the blank occurs. Is there a way to do this, or does the blank that I'm asking for ultimately have to be "blank"? =IF([Alpha-3 Code]@row = "Other", "",…
-
Can I pull a specific value into a cell, if the value in the cell next to it is found in a list?
I am hoping to pull in a specific value from a list that corresponds to the value entered in the cell next to it. For the below example, if the "store" = 0323, then pull in the "group" # from the "group data" # that is next to that "store data" # in a list (i.e. 290). Using the formula =IF(Store@row = [Store Data]@row,…