What's wrong with this formula?

Jason Wirl

Jason Wirl ✭✭

10/14/21 in Smartsheet Basics

=COUNTIF(AD:AD, DAY(@cell) = 16)

I'm getting an #invalid data type error.

Column AD is a Date column and I'm just trying to count the number of days that contain the 16th.

Thank you,

Jason

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

10/15/21

You have either blanks or non-date (text) values in your date column. Try this...
=COUNTIFS(AD:AD, IFERROR(DAY(@cell), 0) = 16)

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

how to get automated workflow to trigger when a new row is added from a form?
I've created the automation below and would like it to run whenever a new row is added from a form. I've tested it out and when i create a new row the automation doesn't trigger- where am I going wrong?
Restore previous version
Hi all - a poorly structured data shuttle update has deleted all my sheet data. I'm on hold to support but does anyone know how to restore a previous version of a sheet?
Creating daily work schedule for individual team members (from a master project grid).
Hello, I'm building a system in Smartsheet to manage work requests across all projects in my organization. The basic idea is for Project Managers to submit task orders to a common grid, which are then assigned to various team members. Ultimately, this new system will serve as the primary work scheduling tool. The system is…

Help shape the future of Smartsheet.
Share your ideas and feature requests.