If a cell does not contain a period

Detrie Zacharias

Looking for the syntax for if a cell does not contain . (a period)

This is not working

=IF([Work #]1 <> "*.*", "No", "Yes")

Andrée Starå

Hi Stavros,

So close!

Remove the *

Try this.

=IF([Work #]@row <> ".", "No", "Yes")

Did it work?

I hope that helps!

Have a fantastic weekend & Happy Holidays!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAAtJREFUCB1jYAACAAAFAAGNu5vzAAAAAElFTkSuQmCC

Detrie Zacharias

Hi Andrée 

Hmm.. It didn't seem to work

Work # is also a formula field. Do I need to use VALUE in the formula?

Andrée Starå

@Stavros_McGillicuddy Whats the formula in Work #?

Detrie Zacharias

=IF(Ancestors@row = 0, [Work ID]@row, (IF(Ancestors@row = 0, COUNTIF(Ancestors$4:Ancestors@row, 1), "" + PARENT() + "." + COUNTIFS(Ancestors$4:Ancestors@row, Ancestors@row, RowID$4:RowID@row, >(PARENT(RowID@row))))))

Paul Newcome

I would suggest a FIND function.

=IF(FIND(".", [Work #]1) = 0, "No", "Yes")

This will generate a "No" if the cell does not contain a period.

Detrie Zacharias

It's trowing a #INCORRECT ARGUMENT SET

Paul Newcome

Can you copy the exact formula and paste it here?

Detrie Zacharias

I found a better way to this using ancestors values

Andrée Starå

@Stavros_McGillicuddy Excellent! How did you solve it?

Detrie Zacharias

I posted a new question HERE that details what I've been trying to do.

I suspect the issue I was having was due my possibly over-complicating things

Paul Newcome

@Stavros_McGillicuddy I posted a possible solution on your other thread that you mentioned above. Does it help any?