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


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Are you able to provide screenshots for reference?

  • Adam1234
    edited 07/08/22

    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.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!