Help: formula won’t apply to a new template
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:
Best Answers

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
Need more help? 👀  Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋  Global Discussions

Hello Genevieve,
It worked! Please see the photo below:
Many thanks for helping me out :)
Answers

Do you have them set as column formulas?

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

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
Need more help? 👀  Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋  Global Discussions

Hello Genevieve,
It worked! Please see the photo below:
Many thanks for helping me out :)

No problem, I'm glad that worked! 🙂
Need more help? 👀  Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋  Global Discussions
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.9K Get Help
 410 Global Discussions
 220 Industry Talk
 458 Announcements
 4.8K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!