Create a summary of errors within a row

Hello, I have a row of that contains information about projects (like project name, project owner, start and finish date) and I want to create an easy way to see the deficiencies in a row. For examples, if a start date is blank.

I've been trying to figure out a way to have a multi-select dropdown show each possible error in one column using formulas and automation but I keep getting stuck. both will only show the first error they find. Any ideas?

Find more posts tagged with

Accepted answers

Paul Newcome

Ok. So instead of nesting your IFs together, try "adding" them together.

=IF([Type of Work]@row = "", "Type of Work is Blank" + CHAR(10), "") + IF([SET Owner]@row = "", "SET Owner is Blank" + CHAR(10), ""), + ……………………………………….

All comments

Paul Newcome

What is the current formula you are using?

Staylo95

=IF(ISBLANK([Type of Work]@row), "Type of Work is Blank", IF(ISBLANK([SET Owner]@row), "SET Owner is Blank", IF(ISBLANK([Project Owner]@row), "Project Owner is Blank", IF(ISBLANK([Executive Sponsor]@row), "Executive Sponsor is Blank", IF(ISBLANK([Definition of Done]@row), "Definition of Done is Blank", IF(ISBLANK(Measure@row), "Measure is Blank", IF(ISBLANK(Mission@row), "Mission is Blank", IF(ISBLANK([Start (Roadmap)]@row), "Start (Roadmap) is Blank", IF(ISBLANK([Finish (Roadmap)]@row), "Finish (Roadmap) is Blank", IF(ISBLANK(Status@row), "Status is Blank", ""))))))))))

Paul Newcome

Ok. So instead of nesting your IFs together, try "adding" them together.

=IF([Type of Work]@row = "", "Type of Work is Blank" + CHAR(10), "") + IF([SET Owner]@row = "", "SET Owner is Blank" + CHAR(10), ""), + ……………………………………….

Staylo95

Sorry for the long delay, I finally implemented this and it worked! Thank you so much!!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

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.