2
votes
Trailing zeros in Google Spreadsheet automatically removed from form submission
In order to keep trailing zeroes of 1 to the 1.0 you just have to klick "Increase Decimal Place"
In order to remove trailing zeroes of 1.0 to the normal 1 you just have to set the number format back ...
- 21
1
vote
How can I manually edit empty cells that are within an array returned by an ArrayFormula function?
You are using an array formula to copy data to columns A1:K. Formula results are always view-only and cannot be edited.
One solution is to mark the key return times in column L instead of column J.
...
- 15.3k
1
vote
Is there a way to add a new sheet tab to a Google Sheet based on the timestamp date?
For form responses received in a spreadsheet, you want to automatically generate a new tab based on the timestamp so that each week has its own tab.
To do this, it is first necessary to identify the ...
- 5,811
Only top scored, non community-wiki answers of a minimum length are eligible