How to prepopulate a form using the row as a reference?
I apologize for the simple question. I am a beginner with Smartsheet but I have not found the question answered in the help sheets. I would like to prepopulate a form answer using the row as reference. I can get the form to prepopulate but I have to enter the address manually in the formula each time. I have multiple unique addresses I would like to prepopulate in the form so the row reference will save me hours.
I am using:
What comes next? The column name is Address and I would like it to grab the text from that row. I have tried multiple ways of @ROW but none return the text.
Help Article Resources
Check out the Formula Handbook template!