Is there a way to reference the value in a cell as a numerical value that functions in a formula
Hi Community,
I have a 13 week rolling chart. To gather, I have groups like this one below for each of the thirteen weeks. this one shows 10. Is there a way to change the value for the weeks ago portion (in red boxes below) to be a value in another cell? In other words, I could reference the 10 in the red box on the far right and this formula would update to be 10 so it's 10 weeks ago. Then I could just repeat for the other 12 weeks. (Ignore the 5 in the formula, I was in the middle of changing this one from 5 weeks ago to 10 weeks ago and had this thought)
Best Answer

Hi @EEK
You can put the value in the same row, over to the right, and use the reference [Column name]@row instead of the fixed number 10
Or if you put it on a different row, you can use the row number instead of @row and a $ to fix the row so if you drag the formula to other rows, it still refers to 15.
Answers

Hi @EEK
You can put the value in the same row, over to the right, and use the reference [Column name]@row instead of the fixed number 10
Or if you put it on a different row, you can use the row number instead of @row and a $ to fix the row so if you drag the formula to other rows, it still refers to 15.

@KPH you are an angel. I tried this before and I couldn't get it to work. Not sure what you've done differently, but it worked immediately. You've saved me from myself.

Thanks for letting me know, always happy to help!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 349 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 282 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!