Cell for entry and look up
![MelissaSan](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Hi,
My finance team has asked me to create a sheet where we are capturing forecasted and actuals. To simplify the example:
they want a Column for each month.
Jan, Feb, March etc…. they want the business to enter a value for each month but when the actuals are in, they want that same cell to be a vlookup and summation from another sheet and then locked.
I don't know if it is possible for a cell to be a formula and accept a value.
Any insight on this?
Best Answer
-
Hey @MelissaSan,
Unfortunately you can't have the ability for both a column formula and accept a value. However, what if you had a master sheet that pulls from two separate sheets, one for Estimates and another for Actuals, then just have it check if the Actuals sheet is blank, use Estimates?
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
Answers
-
Hey @MelissaSan,
Unfortunately you can't have the ability for both a column formula and accept a value. However, what if you had a master sheet that pulls from two separate sheets, one for Estimates and another for Actuals, then just have it check if the Actuals sheet is blank, use Estimates?
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
-
Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 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!