Today Formula

John Littler

John Littler ✭✭✭✭

05/13/24 edited 05/13/24 in Formulas and Functions

Hopefully a simple one here. Trying to calculate number of instances / records per day from a date column?

Sumif ? Today()?

0 ·

Answers

SteyJ Community Champion

05/13/24 edited 05/13/24

Does this work? Let me know.
=COUNTIF([Date Column]:[Date Column], @cell = TODAY())

Sincerely,
Jacob Stey
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

Collect an column entry when data is entered by a form
Hi, I'm still tearing my hair out over this issue, and I'm hoping someone can help me. In our set up that is run through control centre, we have specific information that is entered onto a sheet via a form. I need to link the information that is entered into that form back to the metadata for each project. The issue I'm…
Schedule health formula to display blank symbol
Hello! I am curious how to edit the below formula, to show blank instead of green/yellow/red symbol if status/end date is blank: =IFERROR(IF(Status@row = "Complete", "Green", IF(Status@row = "N/A", "Green", IF([End Date]@row = TODAY(), "Yellow", IF([End Date]@row < TODAY(), "Red", "Green")))), " ")
Count HAS Function Between Dates
I have worked to find a solution out there but not getting one that works. I am collecting data from a sheet to be used in charts on a dashboard (so referencing another sheet). The result will need to be generated from two columns Date - date the project closed Fund - The fund/funds used to pay for the project (multiselect…