Create a summary of errors within a row

Staylo95

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?

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), ""), + ……………………………………….

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. 👍️