Stuck on a due in 7 days formula

Options
Molly12345
Molly12345 ✭✭
edited 02/20/23 in Smartsheet Basics

Hi all. I am stuck on a due in the next 7 days formula. Today is the 17th and I have a due date on the 20th. I have tried the following and kep getting 0. Many thanks in advance


Best Answer

  • Molly12345
    Molly12345 ✭✭
    Answer ✓
    Options

    Hi Paul I got it working in the end and my dates appeared finally =COUNTIFS({PLANNED}, @cell >= TODAY(), {PLANNED}, @cell < TODAY(8)). Thank you for your help, I am learning through your comments |! Have a great week

Answers