What value does MATCH return if it matches nothing?

Wessyl Kelly

Wessyl Kelly ✭

06/23/21 in Formulas and Functions

Or possibly my question is what is the null value in Smartsheet. And does it matter if the context is boolean or not?

Thanks.

Tags:

Formulas

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

06/23/21

If you are using the MATCH function and it does not find a match, you will actually get an error.

#NO MATCH

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Add to INDEX formula to account for blank cells?
I have a mapped column that displays a Contact based on what's inputted in another cell. E.g. Slim J = Slim Julian. Here's the formula: =INDEX({PD - NetSuite Name Mapping USE Range 1}, MATCH([PDS Selected]@row, {Formstack Name}, 0)) However, if the cell is blank, it just assigns the first Contact alphabetically, even…
Fiscal Year "lookup" formula request
Hi :) I'm trying to get this lookup to pull in the FY for us but these always give me a hard time. I have the excel formula but I don't really even understand it so not sure how to translate it to Smartsheet talk. Excel: =LOOKUP(2,1/((H268>='Lookup Data'!$B$2:$B$21)*(H268<='Lookup Data'!$C$2:$C$21)),'Lookup…
Count is not blank
I am creating a sheet summary. I would like it to count only those in January and my column range cells are not blank. I feel like I am so close. =COUNTIFS([Audit Month 2]:[Audit Month 2], "January", NOT(ISBLANK([Test Issue 1]:[Test Issue 4])))