Hello and thank you in advance for any assistance.
I would like a cell to fill-in today's date automatically if there is any value entered in the cell beside of it. I have the following formula that seems to be working to produce this result: =IF(COUNTA(C404)>0,TODAY(),#N/A
In order to see a blank when there is no value in the adjacent cell, I have conditional formatting set to show the "N/A" as white (looks blank) when there is no entry.
This works well for my needs, however the sheet is also filtered. I've tried entering the formula on the unfiltered main sheet and under each separate filtered list but the formula disappears. How can I have this formula appear and work under any filtered results? The sheet is typically filtered by vendor and daily items added.
Thank You.
I would like a cell to fill-in today's date automatically if there is any value entered in the cell beside of it. I have the following formula that seems to be working to produce this result: =IF(COUNTA(C404)>0,TODAY(),#N/A
In order to see a blank when there is no value in the adjacent cell, I have conditional formatting set to show the "N/A" as white (looks blank) when there is no entry.
This works well for my needs, however the sheet is also filtered. I've tried entering the formula on the unfiltered main sheet and under each separate filtered list but the formula disappears. How can I have this formula appear and work under any filtered results? The sheet is typically filtered by vendor and daily items added.
Thank You.
