Can someone help me count tasks coming due (using both original & revised due date columns)?

Hello, fellow Community members! I'm new to formulas/equations in smartsheet and could use your help. I'm trying to create a formula that counts how many actions are due in the next 7 days. The tricky bit for me is that there's both an "Actions Planned Due Date (Original)" column and a "Actions Planned Due Date (Revised)" column. How do I count actions due in the next 7 days, using the revised date column only if it has a date in it, or the original date column if it does not. Thanks for your help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!