Automatic Formula Fill Down Not Working if Copy a Parent Row to Another File
I have 10 archive files (normal Smartsheet sheets) that I use automatic workflows to copy rows to them when processing weekly timekeeping data and closing projects. In addition to the copied columns, I have added additional columns to the archive sheet to allow reports that access the archive sheets to ignore duplicate (obsolete) records as I occasionally need to reprocess weekly results. I rely on Smartsheet automatically filling down these additional column formulas when new rows are added to the bottom of the sheet. I just discovered that one of the 10 archive sheets is not automatically filling down the formulas. This particular archive is unique in my application in that the automated workflow just copies the parent row which then automatically copies the children rows also. Within this sheet neither the parent row or the children rows have the formulas in the additional columns filled down. The other nine workflows just copy one row at a time and the formulas fill down just fine. I can't spot a reason why copying parent rows doesn't trigger automatic formula fill down in the Smartsheet documentation. Is this a bug or intentional?