Can I auto-add a formula to a column that applies as new lines get added?

kwestmark

I've built out a survey for the purposes of an intake form. The team receiving the intake has to respond within 14 days. I wanted to build in an automation to remind the team "response due".

I added a "created date" column, and then I added a helper column which allows me to write a formula to add 14 days to the created date. The automation can then be built but I would have to manually write the formula after each submission which doesn't work for this workflow.

Can I somehow apply a formula across an entire column? Or any other ideas for achieving this?

Nic Larsen

Assuming the formula can be the same, just right click in a cell that has the formula and choose "convert to column formula". This will apply it to entire column including new entries.

Leroy Noriega

Right click the cell with the formula and select 'Convert to Column Formula'.