Isblank function returning value of previous
Hello formula gods,
I need help creating a formula. In my scenario, a user is able to leave certain columns blank after he/she is done completing a form coordinating to a specific project (project A). If the cell he/she leaves a field blank, it indicates that nothing for project A has changed from the previous time project A was filled out. I want the blank cells to automatically grab and show the previous Project A's information on the rows. If an example is needed to better explain what I am talking about, I am willing to create one. I have gotten close with IF, VLOOKUP, and ISBLANK functions, but I am not getting the complete answer I am looking for (maybe a combination of these functions, I am not too sure).
Note that there are multiple projects in the Smartsheet, so I want the formula to coordinate with the proper project.
If anyone has a formula they think could help, I would greatly appreciate it!
Thank you!
Best Answer
-
You would have to set up a different sheet and use formulas with cross sheet references to pull in the most recently added data for each project. You would not be able to do that on this sheet.
Answers
-
Are you able to provide screenshots for reference?
-
Hi @Paul Newcome,
Thanks for your response. Below is a fake scenario I just conjured up to help better explain it. A user creates a form for Project B (red highlight), and leaves certain cells blank(yellow highlight). The blank values indicate that nothing has changed for this project from the previous month (in this case, June to the date he/she filled out the form). I want a formula that automatically transfers the previous data (blue highlight) into the blank cells (yellow highlight). I want it to also coordinate with Project B. I hope this explains it better. Thank you for your time.
-
You would have to set up a different sheet and use formulas with cross sheet references to pull in the most recently added data for each project. You would not be able to do that on this sheet.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!