Tracking Previous Week Order Completions vs This Week

Jen Castillo
Jen Castillo ✭✭✭
edited 07/27/22 in Formulas and Functions

Hello,

This feels like a simple question, but the answer is eluding me. We have dates getting automatically logged for when orders come in/are delivered, and then another automation to log the date when the inspection is completed.

I need to have two different results. One for when an order delivered from the previous week is completed this week, and then a different one for orders delivered/completed in one week.

How would I go about this? Thank you in advance!

Tags:
· Share on FacebookShare on Twitter

Best Answers

  • Jen Castillo
    Jen Castillo ✭✭✭
    edited 07/29/22 Answer ✓

    This worked perfectly! Thank you so much!


    Is it possible to add in another section for orders received 2 weeks back? I don't think we'll be tracking things like that, but just in case.

    · Share on FacebookShare on Twitter
  • Tomasz Giba
    Tomasz Giba ✭✭✭✭✭
    Answer ✓

    Hi @Jen Castillo,

    This formula will give you number of weeks difference between any two given dates:

    =IFERROR(IF(WEEKNUMBER(Completed@row) < WEEKNUMBER(Date@row), WEEKNUMBER(Completed@row) + 52 - WEEKNUMBER(Date@row) + 1, WEEKNUMBER(Completed@row) - WEEKNUMBER(Date@row) + 1), "")


    weeks difference.PNG


    Tomasz Giba

    · Share on FacebookShare on Twitter

Answers

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!