How can I calculate if a date is before or after another date field using Sheet Summary?
I want to count how many rows on a sheet have a date in one column greater than a date in another column.
Best Answer

Yes. It will require a formula.
=IF([First Date Column]@row > [Second Date Column]@row, 1)
As long as there are at least two rows above or below the new row that are of the same hierarchy and contain the formula, the formula will autofill into the newly created row.
Answers

You are going to want to add in a "helper" column and do the initial comparison there. Then you can count how many rows are flagged in your Sheet Summary field.

Does the "helper" column need to have a formula in it then to do the comparison? Because I'm trying to avoid having formula's on the sheet at all since there will be multiple people adding rows to the sheet from forms etc so to keep formula's copied to all the new rows is a hassle.

Yes. It will require a formula.
=IF([First Date Column]@row > [Second Date Column]@row, 1)
As long as there are at least two rows above or below the new row that are of the same hierarchy and contain the formula, the formula will autofill into the newly created row.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 200 Industry Talk
 429 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!