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
Check out the Formula Handbook template!