T
T
this_cold2020-05-31 14:07:05
Google Sheets
this_cold, 2020-05-31 14:07:05

Why are many fields not responding to the formula?

I have a table and several columns, in the formula column, if the value of the start date is empty, then the end date is also empty, however this does not work
TnqyDhP.png

Answer the question

In order to leave comments, you need to log in

2 answer(s)
J
John Smith, 2020-05-31
@ClearAirTurbulence

Your cells are not empty, the data in them - visually empty - is generated by formulas, according to your comment to the question. In such cases, ISBLANK returns FALSE.
Solutions:
- set the date manually (it's rather strange to generate the date of issuance of something by a formula, it must be a hard-coded value)
- change the formula for the date of withdrawal - check not the emptyness of the "date of issue" cell, but, for example, the length of the text in it.

T
this_cold, 2020-05-31
@this_cold

gc6OtDd.png

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question