I want to count how may taks are due tin 7 days from the start date of the activity

abinmoh
abinmoh ✭
in Formulas and Functions

Can someone provide me the formula? i am new to smartsheet

· Share on FacebookShare on Twitter

Answers

  • Zachary Ziegler
    Zachary Ziegler ✭✭✭✭✭

    If your task is due within 7 days from the Start date, that means the Duration field will be less than 7 so the formula would be as follows:


    =COUNTIF([Duration]:[Duration], "<7")

    That should give you the total count of tasks that meet that criteria!

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!