how to use "<>N/A" formula in smartsheet Date column

Genevieve P.

Ok - before we add in the second criteria (EFT is blank), lets make sure we can first get a count from the Date EFT column. Did the ISDATE function work?

=COUNTIF({Master Tax Calendar Range 6}, ISDATE(@cell))

Yashwant Singh

not working again incorrect argument.......

please confirm that @cell for one cell or a range.....

for one cell isdate is working but for all range how we check with countif ..?

Genevieve P.

The @cell function is looking in each cell of the previously stated range, the {Master Tax Calendar Range 6} range.

We use it inside the ISDATE function to indicate that we are looking into the cells of that range. Did it work?

Yashwant Singh

Isdate is working with @cell....

will check @cell and Isdate with other columns and update you...

thanks for your great support @Genevieve P & @Paul Newcome ..

Genevieve P.

No problem!! Team effort 🙂

To add in your second column, try this:

=COUNTIF({Master Tax Calendar Range 7}, <> "", {Master Tax Calendar Range 6}, ISDATE(@cell))

"Range 7" is my guess at what your name will be for the EFT reference. "Range 6" is that date column.

Let us know if you need any other help!

Yashwant Singh

Finally my formula is correct.....💪

.@Genevieve P thanks for your help....!!!!!!

Paul Newcome

@Genevieve P

Genevieve P.

😂😂😂Paul, that's amazing.

I'm glad the formula worked for you, @Yashwant Singh !