So…I thought about a way to input formulas into Google Sheets directly from the submission of a form (I know there are other ways to do this…let’s just say I was bored. )
So anyways - first I created a Text column in the Data Editor, inputted “=NOW()” formula, hit Done and then created a Template column in the Data Editor (let’s call it “Formula Template” for example) and matched the Text column to the Template column…
Then I created a form and created two entries: a checkbox asking the user to confirm their submission, and a Column Template (“Formula Template”) that auto-magically inputs the “Formula Template” into the appropriate column in my Google Sheet…
Yes…it worked…sent the Formula [ =NOW() ] into the Google Sheet …HOWEVER…it doesn’t render/activate the formula…instead it sends this: '=NOW() …and the ’ is recognized as an Automatic Text entry…
…anyone out there know how to make it so “=NOW()” gets input, minus the ’ ?
Thanks for any and all suggestions or help! Thought this could be a neat workaround for some use cases out there! Cheers!
I think any template columns or lookups, etc will show up in the sheet as text (so they get the ’ added in front).
Is there a reason you don’t want to use Arrayformulas for this if you need the formulas to show up in the sheet? Just set up an Arrayformula that will add the formula to a column whenever a new row is added.
With a math column, you can get the current date and time without having to mess with Google sheet formulas. There is a Now function built in. Just enter a value, such as ‘x’ and then replace it with Now.
H is a column in google sheet that contains duration time data.
and # will be replaced with the row number in the google sheet.
I don’t use arrayformulas and prefer to use manual formulas from the Glide template.
because if you use an array formula, glide will enter data at the end of the row or outside the range of the formula array.
Arrayformulas shouldn’t use a defined range. Arrayformulas will apply across all rows. Use H2:H instead of H2:H20. Then delete all empty rows. Any new row will automatically have the arrayformula applied and you won’t be limited by a predefined range.