Welcome!

COUNTIFS to Calculate Tenure within a Date range

I am trying to count the number of our employees that leave in the first 60 days if they were hired in a certain month while referencing another sheet. In my original sheet I have 2 date columns (Hire date and Departure date) then a count field that calculates the net days between the two.

This is the formula I have and I am getting an #INCORRECT ARGUMENT SET error. I am sure it's something simple but need this completed ASAP for a dashboard.

=COUNTIFS({Onboarding Step Tracking Range 1}, @cell >= DATE(2018, 1, 1), {Onboarding Step Tracking Range 1}, @cell <= DATE(2018, 1, 31), {Onboarding Step Tracking Range 4}, <=60)

The last range/criteria is where i am having issues.

Thank you!

Find more posts tagged with

Comments

Paul Newcome

What kind of data is the last range looking at and what type of column is it in?

akrueger

NETDAYS formula and Text/Number

Paul Newcome

Try using an @cell reference in the criteria.

@cell<=60)

Let me know if that makes a difference.

akrueger

I have tried that to get the same error unfortunately!

Paul Newcome

Are you able to share some screenshots of both sheets? Out of curiosity... Look at the source data for {Onboarding Step Tracking Range 4}. Is it left or right justified?

Sign in to join the conversation!

Quick Links

Trending discussions

Which template to choose?
My small civil engineering company is brand new to Smartsheet. I will be overseeing about 70+ projects spread out over 8 engineers in the company. I want to track the status of each project, and add milestones/tasks to each one along the way. Each project also has its own budget. I want to be able to track each project &…
Indent Button Gone
I have not had to create a sheet in a while that requires indenting, but it seems like the buttons for that have been removed. Is that true or amy I missing something? I have something in each row and I am an admin.
Report not filtering all of a sudden anymore
A report that I use everyday is all of a sudden not filtering anymore. It is a big report that is way over the 2500 that can be displayed. Normally I can filter by a work order and will pull up all info that goes with that work but fore some reason it is not filtering now.