Data from Form Entries not staying centered and wrapped

Crystal Perry · 06/03/22

When data comes in via a form, it does not maintain the formatting that I have on my sheet. I want all of my data centered and the text wrapped but it never comes in that way from the form. Is there a way to keep the data formatted? Also keep having commas randomly added to numbers over 1000 but I don't want them to. It isn't every entry either, just random.

Andrée Starå · 06/03/22

Hi @Crystal Perry

I hope you're well and safe!

Try selecting the whole column(s) and change the format.

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Crystal Perry · 06/03/22

No it only corrects the data that is already in the sheet but when the new form data comes in, it loses the formatting again. This has been happening for months now.

Crystal Perry · 06/13/22

https://community.smartsheet.com/discussion/comment/331909#Comment_331909

No it only corrects the data that is already in the sheet but when the new form data comes in, it loses the formatting again. This has been happening for months now.

Data from Form Entries not staying centered and wrapped

Answers

Categories