=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
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!
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
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 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?
ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.
