Display a message / Instructions if cell is empty

Chris Kidd · 04/30/20

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?

Andrée Starå · 05/01/20

Hi Chris,

If I understand correctly, something like the following will work, but you’ll need to add a so-called helper column to display the message.

Try something like this.

=IF(ISBLANK([Plates Made By]@row); "Info is missing")

The same version but with the below changes for convenience.

=IF(ISBLANK([Plates Made By]@row), "Info is missing")

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Make sense?

Would that work?

I hope that helps!

Be safe and have a fantastic weekend!

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!

Andrée Starå · 05/01/20