Tracking Previous Week Order Completions vs This Week

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


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!


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!