Can I get help with this (repost)?
=IF(ISBLANK(MBE@row, WBE@row, MWBE@row, DBE@row, ACDBE@row)," ", "Done")
@Mike B
=IF(AND(ISBLANK(MBE@row), ISBLANK(WBE@row), ISBLANK(MWBE@row), ISBLANK(DBE@row), ISBLANK(ACDBE@row))," ", "Done")
In English, If all the fields are blank, leave this cell blank, otherwise, set this cell to "Done".
Hi @Mike B
I hope you're well and safe!
Can you elaborate on how you'd like it to work?
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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Hi Andree, I was trying to return a value if any one of the five cells were not blank.
Perfect. Thanks!!!!
I saw that Jeff had answered already!
Here's another option and the one I would use.
=IF(AND(MBE@row = "", WBE@row = "", MWBE@row = "", DBE@row = "", ACDBE@row = ""), " ", "Done")
Let me know if I can help with anything else!
Andrée
✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!
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.
