Autofill formulas not applying per conditions

Bryan Dehmler-Buckley

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?

Thanks,

B

Andrée Starå

Hi Bryan,

Strange!

I'd be happy to take a look and see if I can find what's wrong!

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

Are you entering data into the Primary column? The autofill will not kick-in while the Primary Column is blank.