Why is this column formula returning 'External' when the email obviously does contain 'iris' ?

Steve_Iris

Steve_Iris ✭✭

10/15/24 edited 10/15/24 in Formulas and Functions

The contacts columns is set to allow multiples

0 ·

Answers

Steve_Iris ✭✭

10/15/24

It seems to be that it can't interrogate contact lists very well

0 · Share on Facebook Share on Twitter
David Tutwiler Overachievers Alumni

10/15/24

CONTAINS does not work well with contact lists. You can use FIND instead and it should work. Here is an example you can try:
=IF(FIND("iris", [Assigned To]@row) > 0, "iris", "External")

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

CountIFS contact is in a contact list
=COUNTIFS({TEST Range 1}, ="*Name*", {TEST Range 6}, ="DO") Hi all, this is a helper sheet used to get the counts of different conditions. Test Range 1 is a contact list that can contain multiple contacts, how can i make it so that i can check if "Name" is in the list. It is currently returning 0 when it should be finding…
Character Limit Formula
I'm unable to convert this to column formula (probably due to the reference to my 'blank' column… However, this formula doesn't work, =IF(LEN([Source Admission ID]) >= 21, "Source Admission ID Limited to 20 VARCHAR", "") So, I changed it to this, which works… =IF(LEN([Source Admission ID]) >= 21, "Source Admission ID…
Invalid column value when both columns are text
hello! So this formula worked for a second and then for some reason stopped when i changed the return text from its original 'test' to 'half' . But it's still working on the column to return dates its just the text/number rows not working. The reference and return columns are all text/numbers. I am trying to reference a…