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.
Thanks for the reply! Yeah, thatās what I currently do; was just wondering if there was actually any use(s) to this. Maybe on a per-cell-input basis?
I kind of use the same method to populate cells when arrayformula doesnāt work (custom functions etc.), but with Scripts. Glide would always write the =NOW() as text.
I do this with scripts. I save all my formulas that cannot be arrayformulas on a separate tab and when specific columns are edited my script takes the correct formula and adds it to the row.
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.
And make it an arrayformula? Should work with yoru original formula anyway but I donāt know why you use āH#ā? It implies you are not using an arrayformula right?
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.