I'm creating a sheet where I would like the user to input three values (property name, old property code and new property code) one time, and then I want a helper column to concatenate those values as a column formula so it applies it to every row in the sheet. I will then have an automation that automatically sends the rows that are assigned to the appropriate contact with other information from the row, but I also want the row grid in the email to show the property name, old property code and new property code.
I can't figure out how to get the property name/code field to populate with the value. The formula I'm using is below, which is looking for the value @row and since that value only exists in the first row it's not picking up for the other columns. I tried reference [Property Name]1 instead of @row but that won't work.
Any ideas to get the values into the rows - or even better, is there a way to have the property name, old and new property code fields populated dynamically in an automated email message vs me having to add it as a field for the table embedded in the email?
="Property Name: " + [Property Name]@row + CHAR(10) + "Current/Old Property Code: " + [Old Property Code]@row + CHAR(10) + "New Property Code: " + [New Property Code]@row
