I can't find which column is "frozen"
I am working on a sheet built by another person, and they have frozen a column, but I'll be darned if I can find which one it is, and I've right-clicked on every column, and not seen an "Unfreeze Column" option listed.
Any ideas how I can clear the Freeze Column?
Thanks.
Best Answer
-
保罗H ✭✭✭✭✭Maybe try switching from Gantt to Grid, then unhide all columns
Answers
-
Sameer Karkhanis ✭✭✭✭✭✭
The column that is frozen is always the one to the left (of the divider) from where the slider starts scrolling horizontally.
-
Dennis M Wierzbicki ✭✭✭✭✭
Nope. It looks like it's frozen where the sheet ends and the timeline begins, but there is no option to unfreeze any of the columns. Like I said in my OP, I've looked at ALL the columns, and not one has the option to "Unfreeze Column" available.
-
Sameer Karkhanis ✭✭✭✭✭✭
Do you see a vertical divider line and two sections that are horizontally scrollable? If no, then may be none of the column is frozen. Please share the sheet or screenshot.
-
Sameer Karkhanis ✭✭✭✭✭✭
Column that is frozen will have the "Frozen Column" in menu disabled when you right click on the column header.
-
保罗H ✭✭✭✭✭
Maybe try switching from Gantt to Grid, then unhide all columns
-
Dennis M Wierzbicki ✭✭✭✭✭
That was it! The frozen column was hidden. Thanks.
Categories
@Devi<\/a> The error message is telling you what you need to know... There are hard cell limits for each sheet, so you'd need to find a way to either manage the data some other way, or limit the data going into the sheet.<\/p> I ran into a similar situation when writing a program to write thousands of rows into a sheet. In that scenario I was able to have the script check for older rows that were no longer needed and delete them from the sheet before adding new rows.<\/p> Another alternative is to contact Smartsheet support. They may be able to raise the limit on a case by case basis... But there will still be a limit.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-11 20:34:26","updateUser":{"userID":152152,"name":"Devi","url":"https:\/\/community.smartsheet.com\/profile\/Devi","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp4rvk8Asc5h-24X4OlnhbD6O4k53ZGyjV1tocVb=s96-c","dateLastActive":"2023-01-11T20:32:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":99383,"type":"question","name":"What date format works for Power Automate to input a date in Smartsheet?","excerpt":"I am creating a Power Automate flow to input Form entries into a new row in Smartsheet. I am using Microsoft Forms and not Smartsheet's form because Power Automate will also perform other actions outside of smartsheet. One of my form fields is a date entry. I am trying to get Power Automate to enter this in a Date field in…","categoryID":320,"dateInserted":"2023-01-07T23:00:39+00:00","dateUpdated":"2023-01-09T08:47:14+00:00","dateLastComment":"2023-01-09T16:55:35+00:00","insertUserID":156594,"insertUser":{"userID":156594,"name":"Brant F.","url":"https:\/\/community.smartsheet.com\/profile\/Brant%20F.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-23T17:33:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":136737,"lastUser":{"userID":136737,"name":"Toufong Vang","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Toufong%20Vang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/n65S9PRP4PA0M.png","dateLastActive":"2023-01-28T06:16:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":43,"score":null,"hot":3346416374,"url":"https:\/\/community.smartsheet.com\/discussion\/99383\/what-date-format-works-for-power-automate-to-input-a-date-in-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99383\/what-date-format-works-for-power-automate-to-input-a-date-in-smartsheet","format":"Rich","lastPost":{"discussionID":99383,"commentID":356417,"name":"Re: What date format works for Power Automate to input a date in Smartsheet?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/356417#Comment_356417","dateInserted":"2023-01-09T16:55:35+00:00","insertUserID":136737,"insertUser":{"userID":136737,"name":"Toufong Vang","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Toufong%20Vang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/n65S9PRP4PA0M.png","dateLastActive":"2023-01-28T06:16:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-23T17:36:53+00:00","dateAnswered":"2023-01-09T16:55:35+00:00","acceptedAnswers":[{"commentID":356417,"body":" @Brant F.<\/a>, Hi, Brant, the correct format is a string, yyyy-MM-dd.<\/p> Cheers!<\/p>
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/4W8MCMAUVVVK\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-23 17:36:53","updateUser":{"userID":156594,"name":"Brant F.","url":"https:\/\/community.smartsheet.com\/profile\/Brant%20F.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-23T17:33:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"title":"Trending in API & Developers","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">![https:\/\/us.v-cdn.net\/6031209\/uploads\/LEK3VWQHF4V0\/image.png<\/a><\/p>","bodyRaw":"[{\"insert\":\"Maybe try switching from Gantt to Grid, then unhide all columns\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/LEK3VWQHF4V0\\\/image.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/LEK3VWQHF4V0\\\/image.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]","format":"rich","dateInserted":"2022-05-19T21:27:11+00:00","insertUser":{"userID":748,"name":"Paul H","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20H","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4B2ZHK6WTG0P\/nCNUXTFBXTV5W.jpg","dateLastActive":"2023-01-28T05:48:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/330386#Comment_330386","embedType":"quote"}">](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/LEK3VWQHF4V0\/image.png\"){kind=link}
