How do I combine the following formulas?

Sandi Meikle

=IF(LEN[Cardholder Employee ID]@row = 9, "Yes")

=IF(LEN[Cardholder Employee ID]@row <> 9, "No")

Or how to count the number of numerical characters in a cell? the count is not working for some reason

Sandi

Andrée Starå

Hi @Sandi Meikle

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

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

Genevieve P.

Hi @Sandi Meikle

Andree suggested, it would be easier to help if we could maybe see a screen capture of your sheet (but please block out any sensitive data!).

Otherwise, it looks like you just need to add in the "False" element of an IF statement. The False element essentially says, if the previously stated criteria is not met, return this instead.

=IF(LEN([Cardholder Employee ID]@row) = 9, "Yes", "No")

Hope this helps!

Cheers,

Genevieve

Sandi Meikle

Thank you both! I found another work around, we are trying to limit the number of charcters in a field, but that does not seem to be an option at this point. I appreciate both of your feedback!

Sandi

Andrée Starå

@Sandi Meikle

Excellent!

You're more than welcome!

You could maybe show a message instead of Yes/No, depending on the character count as a possible workaround.

Would that help?