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!