If cell is blank copy value from other column in same row?
I have a form our Sales team uses for customer interactions. I'm trying to work around the inability of Smartsheet to copy only specific cells from one sheet to specific cells in another sheet. I thought if my workflow copies the columns from the source sheet with the form attached to it to the destination sheet and then write formulas in that sheet to show the data from one of the copied columns in the EXISTING column if it's not empty. I could then hide the "new" columns. I was thinking something like the below formula might work but, it's producing a #CIRCULAR REFERENCE....
=IF(NOT(ISBLANK([Customer Name]@row)), "", ([Account Name]@row))
Does anyone know if this is possible and if so, how I might write the formula? The 2 columns I'm working with for this test are "Customer Name" (existing column) and "Account Name" (copied column from sheet with form).
Help Article Resources
Check out the Formula Handbook template!