Want to Count "Total number of Tasks that are due in next 7 days"

Rafsun RoyalRafsun Royal ✭✭✭✭✭
edited 12/09/19 in Using Smartsheet
11/29/18 Edited 12/09/19

Want to Count "Total number of Tasks that are due in next 7 days"

Currently using this but doesn't work: 

=COUNTIF([Production Move Date]14:[Production Move Date]149, >=TODAY(7))

Please Help!

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Rafsun,

    Try this. (Change Date t your column name)

    =COUNTIF(Date:Date; <=TODAY(7))    

    The same version but with the below changes for your and others convenience.  

    =COUNTIF(Date:Date, <=TODAY(7))

    Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

    I hope this helps you!

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Rafsun RoyalRafsun Royal ✭✭✭✭✭

    Thanks Andree!

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Happy to help!

    Have a fantastic weekend & Happy Holidays!

    Best,

    Andrée

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.