Help: formula won’t apply to a new template

therapy_mindset

hello, when a new templete is submitted, my formula won’t apply to the new row. Other columns will apply the formula, however “End Time Parse Left” won’t.

How can this be resolved?

please see photo below:

Genevieve P.

Hi @impressiveace

Try adjusting your row references (in the image above you have 71) to be @row instead.

=IF(LEN([End Time]@row) = 3, VALUE(LEFT([End Time]@row, 1)) * 60, VALUE(LEFT([End Time]@row, 2)) * 60)

Then once you've adjusted your formula, you can apply it as a Column Formula so it's locked to the column. Right Click on the cell and this is one of the options in the dropdown list! See: Use column formulas to apply calculations to all rows in a sheet

Cheers,

Genevieve

therapy_mindset

Hello Genevieve,

It worked! Please see the photo below:

Many thanks for helping me out :)

Paul Newcome

Do you have them set as column formulas?

therapy_mindset

What do you mean by column formula? Please see the photo below:

Genevieve P.

Hi @impressiveace

Try adjusting your row references (in the image above you have 71) to be @row instead.

=IF(LEN([End Time]@row) = 3, VALUE(LEFT([End Time]@row, 1)) * 60, VALUE(LEFT([End Time]@row, 2)) * 60)

Then once you've adjusted your formula, you can apply it as a Column Formula so it's locked to the column. Right Click on the cell and this is one of the options in the dropdown list! See: Use column formulas to apply calculations to all rows in a sheet

Cheers,

Genevieve

therapy_mindset

Hello Genevieve,

It worked! Please see the photo below:

Many thanks for helping me out :)

Genevieve P.

No problem, I'm glad that worked! 🙂