Google Sheets formatting during Google Forms increment.
Cyril
-
Cyril -
Cyril -
Hello,
I am facing a formatting issue with my table (sheet) when incrementing a new result from a Google form.
I have formatted my table to achieve automatic line breaks and thus automatic cell width expansion when the text is too long. For existing results, there are no problems, and when I do this, I select the entire table, including the empty cells that are supposed to accommodate new results.
However, each time I receive a new result incremented from a new response from the form and a free text that is a bit too long for my cells, the line break does not occur. The formatting is lost, and I have to consistently redo the formatting.
This is a big problem for me and for the usage I want to make of it.
How can I resolve this?
I am facing a formatting issue with my table (sheet) when incrementing a new result from a Google form.
I have formatted my table to achieve automatic line breaks and thus automatic cell width expansion when the text is too long. For existing results, there are no problems, and when I do this, I select the entire table, including the empty cells that are supposed to accommodate new results.
However, each time I receive a new result incremented from a new response from the form and a free text that is a bit too long for my cells, the line break does not occur. The formatting is lost, and I have to consistently redo the formatting.
This is a big problem for me and for the usage I want to make of it.
How can I resolve this?
Related links:
- Conditional formatting for deadlines Google Sheets
- Google Sheet: Prevent cell deletion without verification
- Google Sheets: Format a row based on whether the date is past or not.
- Formatting Sheet and Adding Color
- Google Sheets: Conditional Formatting for Expired Dates.
- google forms request for write access