Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Hi!
I would like to know is this kind of formula available in smartsheet?
=IF(ISNA(VLOOKUP(C2;I:I;1;FALSE));"NO";"YES")
In short- If there is the same name in other collumn mark YES
Thnak you!
Hi Someone,
Yes, there is that kind of formula in SmartSheet.
If your column is a checkbox then the formula could be:
=NOT(ISERROR(MATCH([Find this]2, [In this]:[In this], 0)))
If you want those Yes/No answers then the formula could be:
=IF(ISERROR(MATCH([Find this]2, [In this]:[In this], 0)), "No", "Yes")
Personally, I prefer the former and the boolean result can be tested more robustly in other formulas (i.e. any misspelling yes or no is avoided).
Cheers,
Rob.
Hi again,
Just realised that you may have a blank entry in your "Find this" field and wish to treat that as "not found" in the array. Thus,
=AND([Find this]2 <> "", NOT(ISERROR(MATCH([Find this]2, [In this]:[In this], 0))))
Hi, thank you for your reply.
But the last formula is not working, error is #INVALID COLUMN VALUE
What could be the issue?
The first formula must be in a column of type Checkbox as it returns a boolean value.
The second formula must be in a column of type Text/Number as it returns text.
My second post also requires a column of type Checkbox.
Hope that resolves the issue.,
