I have a sheet that has orders entries from the last 6 months. This sheet continues to populate as more orders are made. This is just my repository sheet. I am looking to get the week over week change metrics for the last 7 days. Here's the formula that can provide me that week over week change: Week over week %% = ((current week - previous week) / previous week) x 100 I am not sure how to insert a formula that will provide me that info for the last 7 days. I would like this to appear in one cell and changes as changes are made in the main sheet. Any help would be grateful. Thanks

I GOT IT. =(COUNTIFS({Project}, @cell <> "", {Created}, AND(@cell >= TODAY (-7), @cell "", {Created}, AND(@cell >= TODAY (-14), @cell "", {Created}, AND(@cell >= TODAY (-14), @cell <= TODAY(-8))) Since I am referencing another sheet, no need to add [Project]:[Project]. @Ashley Knight / @Genevieve P. Thank you both to getting me to this point. Thanks again. 🙂

Week Over Week Change

Options

Answers

Genevieve P. Employee

01/15/25

Hi @Cristian
Thank you for following-up! Yes, exactly! Cross sheet formulas use cross sheet references versus column references. 🙂
I'm glad to see it's working for you, now!

Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Incorrect Argument Set
It seems I have problems with the SUMIFS formula. Tried replicating one that works and that was a no go. =SUMIFS({031-Purchase Order - Completed}, "Completed", {031-Purchase Order - Amount}, {031-Purchase Order - Year}, 2025) I want to sum together completed invoices by year. Thank you in advance. Ali
SUMIF and NOT Functions
I am working with three formulas to collect data in the Summary. I want to add the NOT Function to these formulas to exclude the rows that are starred in the CCC column. =SUMIF({Region}, "Philadelphia", {Contracted}) =SUMIF({Region}, "Philadelphia", {07/09/25}) =SUMIF({Region}, "Philadelphia", {Difference}) Thank you
Change formatting based on new date input
Background Currently, I am tracking whether a person attended a visit on a certain date and color coding for easy reference. Each row represents a person These dates are at regular intervals, so I'm using a column formula to calculate what the dates should with each each column referencing the column before it as long as…

Week Over Week Change

Answers

Help Article Resources

Categories