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 ?

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

Can't get IF formula to work,
I have two columns with numbers, and one column with at checkbox, I want to use IF to automatically check the box if the cell in column 2 I bigger than the cell in column 1. This is my formula in the the checkbox column =IF([Column 2]@row<[Column 1]@row) 1, 0 But I keep getting the Unparseable message
Invalid Data Type Error
I have two formulas on different Grids doing the same thing. Formula 1 works, but formula 2 does not. I have double checked the data types of all references and they are the same in both formulas. ={T-Cost} * SUMIFS({T-Total}, {T-Date}, AND(MONTH(@cell) = $Month@row, YEAR(@cell) = [2024]$1)) ={Tourn - Cost} * SUMIFS({Tourn…
Percent formula for drop down fields
I have a column with the following options for drop down fields: NA, Not Started, Required, Drafted, Posted What formula can I use to show me % complete (posted) without taking into account the NAs?