Greetings,
I am developing a solution that automatically captures a 24-hour time (as an integer value) from the generated system date/time. The goal is to allow users to use a form on a tablet to enter a few fields of information into three sheets. My solution converts the times in each sheet correctly:
Above is a portion of my test data. The first column highlighted in yellow is a conversion of the automatic system date/time (in gray). The second and third yellow columns are references from other sheets that use the same formula to calculate the 24-hour conversion.
My issue comes from trying to update the sheet with a form. When a new line is submitted, the formula behaves strangely.
Above is the same data as before, but with a new record submitted. Now, the formula calculation will work for some, but add a comma, or return an error for others.
What's even stranger is that when I open up the sheet and save, the data goes back to the intended values.
I will add that the formula for my conversion is complex (about 518 characters) with multiple chained functions. Any thoughts on why I need to do this "manual refresh" for the formulas to work?
Thank you