Prepopulate information in forms

Adam1234 ✭✭
edited 09/16/22 in Formulas and Functions

Hello everyone,

I am trying to create a Smartsheet form that would automatically populate information when a user fills in a form and leaves certain columns blank. When a user leaves certain columns blank, it indicates that nothing has changed for that specific project so far. For example, if there are 10 unique projects, and a user needs to update the information for project 5 in the month of July. The information placed in the Smartsheet for June is the same for July, so the user would leave all of the columns blank.

I want the previous information (June) to automatically be placed in the new row (July) since there were no changes. I have gone about this in many ways (IF/ISBLANK statements, automations, update requests), but none of them seem to give me the answer I am looking for. I think a formula is probably the best way to go about this, but if anyone has had a similar issue or an answer please let me know. Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!