Trying to capture past dates and future dates

So, I have a column where I can predicted dates (to pay an invoice). Some of these values are past the predicted date of payment. Therefore, I want to make a formula that will capture all those whose date is in the past and those invoices whose predicted pay day is in the next 30 days. So far,

I am only able to do :

=SUMIFS({UDA}, {UDM}, $[30 Day]$1, {UID}, $ID@row, {UTY}, $[REPORT 1 - Invoices by Category (next 30 days)]@row)

Which only adds the invoices that fall on the 30 days for the future.

Any help :D

Tags:

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!