Needed Remedial Sheets Formula Help: Uncategorized Transactions

Ask Anything
1

I’ve actually seen this on a Tiller sheet but now I can’t find it on any of them.

I want a quick and dirty indication of any uncategorized transactions.

One cell (preferably on my Balance sheet) that says TRUE if there is a blank cell in column D of the Transactions sheet.

I keep trying to create something with ISBLANK but I keep doing it wrong. Could someone please rescue this lamo with the correct formula I need?

TIA

2

I’d use something like this, @susandennis:
=countif(D2:D,"")>0

Hope it helps.

3

Perfection!! I was barking up the wrong tree and barking wrongly.

I can stick this on all my tabs as a good reminder.

Thank you so much.

1 Like