Ask Your Question
0

Data Validity Custom Formula issue; stop with error message when another cell is empty [closed]

asked 2020-09-19 15:41:00 +0200

appreciatethehelp gravatar image

updated 2020-09-19 22:01:11 +0200

I'm trying to use a formula in Data Validity to create an error message when trying to enter any character in a specific cell when another cell remains empty- creating a "stop" with "error message".

In the attached example I want entry into B2 to result in stop with error message only when A2 is empty. C:\fakepath\Data Validation Issue.ods

I've never used a custom formula in validity before and I clearly haven't grasped how it works- can someone put me right here?

Thanks.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2020-09-19 22:01:33.402540

Comments

I clearly haven't grasped how it works

Formula evaluates to TRUE -> Data entered is valid -> Error Alert -> Action not being called
Formula evaluates to FALSE -> Data entered is invalid -> Error Alert -> Action will be executed

(hence you get an error if there is already data in your cell A2)

Opaque gravatar imageOpaque ( 2020-09-19 17:28:02 +0200 )edit

1 Answer

Sort by » oldest newest most voted
2

answered 2020-09-19 16:17:45 +0200

erAck gravatar image

Your IF(A2="") returns TRUE if A2 is empty or a formula with empty string result, else FALSE. You want the opposite, and instead of testing for a string it's best to test if the cell is not blank, i.e. has content, so for valid input test

NOT(ISBLANK(A2))
edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2020-09-19 15:41:00 +0200

Seen: 23 times

Last updated: Sep 19