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:

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.

  • 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), "")



    Tomasz Giba

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!