how to use "<>N/A" formula in smartsheet Date column
Answers
-
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))
-
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 ..?
-
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?
-
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 ..
-
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!
-
Finally my formula is correct.....💪
.@Genevieve P thanks for your help....!!!!!!
-
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
😂😂😂Paul, that's amazing.
I'm glad the formula worked for you, @Yashwant Singh !
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!