Autofill formulas not applying per conditions


I have two formulas in my sheet, one that populates with different symbols and one that triggers a checkbox.  One formula is using reference to @row while the other is using a specific row number. The formulas are applied to all rows in their respective columns.

Neither of the formulas is getting updated when a new row is added to the sheet.  It doesn't matter where the row is added (topmost row, between two rows that already have the formulas applied, bottom of the sheet, etc.).  I have read the article from Support about Autofill conditions and have ensured that the requirements exist for Autofill and still no luck.

Can someone please help me figure out how to dynamically apply formulas so I don't need to update my sheet manually?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!