Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

How can I count date columns but exclude some

So I want to count a range of columns that have dates in them but exclude certain columns if the date is part of a formula.

The use case is a training matrix.

Each person has 2 columns.

eg - "John Doe" is a date column and will get set a date when John Doe is trained to an item (Items are rows)

"John Doe retrain date" is a date column and value is set by adding "Retrain cadence" cell which is a duration and "John Doe" cell which is a date.

So row 1 might be "Document X" (Colum name "Item" ) which John Doe needs to train to.

Say John Doe trains to item today column is set to "05-Feb-25" .

Retrain cadence is "5d" so "John Doe retrain date" auto sets to "10-Feb-25".

I want to be able to count only the trained date ie "John Doe" value. And want to count this for multiple users (each user will have 2 columns).

So I want to only count the trained date column values and exclude the retrain date column values.

Hope this makes sense

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions