How can I get a count of new rows created on two sheets?

CSK

CSK ✭

08/14/24 in Formulas and Functions

=COUNTIFS({Created 2}, IFERROR(MONTH(@cell ), 0) = 5, {Created 2}, IFERROR(YEAR(@cell ), 0) = 2024)@cell

Tags:

Formulas

0 ·

Answers

NickStaffordPM ✭✭✭✭✭

08/14/24

Could you provide some more context/screenshots of the smartsheet with private data removed that could help us find a solution for you ?

If you found this comment useful, please let me know by clicking one of the buttons below: Awesome, Insightful, Upvote, or Accepted Answer. Your feedback will assist others looking for the same information and also help me out.
Thanks!
Nick Stafford
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

If formula with Date and Time
Hi. I created the formula below to close a dynamic view on Oct.30th. =IF(TODAY() <= DATE(2024, 10, 30), "Open View", "Lock View") How do I adjust that formula so that the view can be locked at 5pm on that day?
Using a COUNTIF but need two criteria
Hello, I have a master data sheet with all my information and another sheet where I have my KPIs/metrics & formulas. I am currently using a COUNTIF formula =COUNTIF({Project List Range 1}, Labels@row) this is counting how many projects I have in each status (new, in process, pending, etc.) I would like to add another…
SUMIFS formula syntax
Hi, I believe I'm needing help with the syntax for the SUMIFS formula. See the below photo with example data: I am wanting to total the revenue generated for each department (category) and sub department (topic) only if the status is labeled "Won" - which the above screenshot would not be included in the total. The "Topic"…