# of tasks based on due date and owner

PM_Ninja312

PM_Ninja312 ✭✭

10/12/22 in Formulas and Functions

What Smartsheet formula would be best to get the count of tasks due within 10 days if the owner equals "client"?

Tags:

0 ·

Answers

Michael Culley ✭✭✭✭✭

10/12/22

I would do :
=COUNTIFS(owner:owner, "client", date:date, <=TODAY(+10))

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Converting a date/time text format to a simple date format
Hey everyone - I am trying to convert a text field that reads 2024-09-25 15:35:27 to a simple date format, either 2024-09-25 or 9/25/24. I've tried using a helper column to just pull out the text date string - =LEFT([Registration date]@row, FIND(" ", [Registration date]@row) - 1) in the hopes that would be convertible to a…
what is wrong with my formula join collect?
=JOIN(COLLECT({Rollup Tracking: Preceptor Activity Month}, {Rollup Tracking: Preceptor Activity Preceptor Name}, [Preceptor Name]@row, {Rollup Tracking: Preceptor Activity QTR}, Qtr@row, {Rollup Tracking: Preceptor Activity Year}, Year@row), CHAR(10)) I cannot see why this doesn't work…i have similar formulas on other…
How can I display data horizontally from data in a row format
I have metric data on a project that I am capturing weekly that I would like to view horizontally week over week for the current month. I'd like to do this dynamically so I can pull the data into a dashboard. This is what I have in my metrics sheet: This is how I would like the data displayed: Any advice you can provide to…