Display a message / Instructions if cell is empty


If I have a cell that needs input, like a persons name, but if that info is not filled out based on another column how would I make it generate or display a message?

I have column - Plates Made By, I want a message to display if this info is missing.

Based on column(s),Column - # of Plate Made, Column - Shift, Column - Plate Size (Inches) Column - Date Plates Made, so that if data is in these columns it displays that info is missing from Column - Plates Made By

But when I tried it with an =IFERROR([Shift]@row,"")statement it locked the cells to where they would not have any info put in them? it shows an "fx" statement in card view?

Best Answer