How can I build a sheet with more then 200 columns

Mrudinski

I have a safety survey form that I have built a form for. It has more then 200 questions on the form. The sheet only allows 200 columns. I really need this form and the information. What are my options to capture data from this form? Is there a workaround? Help please.

Mike

Carson Penticuff

The column limit should be 400. There is also a 500,000 total cell limit, so if you have 2,500 rows your columns will be limited to 200.

https://help.smartsheet.com/articles/504616-inserting-deleting-renaming-columns

Mrudinski

Carson,

I do only have 200 columns; I have no idea how many rows I have. Do you know how I can see that. It stops at 50 rows.

Is there a setting or way that I can adjust that.

Carson Penticuff

If you had more than 50 rows, you would be able to see them. What happens when you attempt to add the 201st column?

Mrudinski

Well, I just found out that I can add it. My assistant was relaying information. So, we created a form with all of the questions. The sheet did not populate properly from the form. The sheet only shows 136 of the over 300 questions and answers. So, we have several questions on the form that are not associated with the sheet. Do you know how to fix that?