See all How-To Articles

How to Get Rid of the Red Triangle in Google Sheets

This tutorial will demonstrate how to get rid of the red triangle in Google Sheets.

 

red triangle visible

 

A red triangle appearing in the top right hand corner of a cell in a Google Sheet indicates an error.

Data Validation Warning

If you have a data validation rule in your cell and the value entered does not fall within the data allowed, then a red triangle will appear. To remove the red triangle, you need to ensure that the value that you enter falls within the range allowed.

 

red-triangle data validation error

 

Type in a valid value to remove the triangle.

 

red-triangle data validation remove

 

Formula Error

A red triangle will appear if there is an error in your formula.

 

red triangle formula error

 

If you have entered a formula incorrectly, then the #NAME message will appear.

 

red-triangle formula name error

 

To remove the red triangle, fix the formula.

 

red-triangle formula error fixed

 

Lookup Error

You’ll also see the red triangle if you use the VLOOKUP or HLOOKUP Function in Google Sheets and the value is not found.

 

red-triangle formula lookup error

 

The only way to remove this error is to amend the lookup formula; it may be that you have not included the correct range to look up!

Value Error

A value error will occur if you have tried to include data in a formula that is not actually a number.

 

red triangle value error

 

You can’t stop these red triangles from being visible if we have an error in your Google Sheets. They help you see where the error is and help to solve it!