How can I calculate if a date is before or after another date field using Sheet Summary?

Ben Paskewitz

I want to count how many rows on a sheet have a date in one column greater than a date in another column.

Paul Newcome

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.

Paul Newcome

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.

Ben Paskewitz

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.

Paul Newcome

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.