Prepopulate information in forms
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!
Help Article Resources
Check out the Formula Handbook template!