Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
Last Column not available for view. -- recovered!
I have a large sheet (48-50 columns by 80 rows). I can not see the last column. It has a formula that displays either "not done" or "done". I use it to highlight "done" rows in green. I was working on another indicator and wanted to access that column and couldn't scroll over to it. Have I met a limit on the width of the sheet? I have been able to add columns as I am still improving the sheet functionability. I entered a bit of sample data in a line 2 below real data and the formula didn't fill down. Solutions?
I want to see the column and easily access it.
I went back and moved the second to last column to the right and discovered that the "last" column was collasped to a thin column. I expanded it and it appears fine now.
Sorry for any inconvience.
Comments
-
J. Craig Williams ✭✭✭✭✭✭Lou,
If a column gets hidden, either on purpose or on accident, you can click the down arrow on any column header and select "Unhide All Columns"
It will do exactly that - if you have a lot hidden (like I sometimes do), the you need to hide them all over again, but you'll at least have the "missing" one back.
Craig
Categories
=MAX([Modified]:[Modified]) + \"//m.santa-greenland.com/community/discussion/4582/\"<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":107030,"type":"question","name":"How to subtract percentages?","excerpt":"I created a new column % Not complete and am trying to add a formula to have =100%-[%Complete]@row. Answer #UNPARSEABLE I have also tried =100-%Complete]@row. Answer: This will populate an answer, however I cannot adjust the formatting from % to number Example: %Complete = 13% Correct answer should display 87% Second…","snippet":"I created a new column % Not complete and am trying to add a formula to have =100%-[%Complete]@row. Answer #UNPARSEABLE I have also tried =100-%Complete]@row. Answer: This will…","categoryID":322,"dateInserted":"2023-06-28T15:56:57+00:00","dateUpdated":"2023-06-28T16:22:44+00:00","dateLastComment":"2023-06-28T16:35:48+00:00","insertUserID":150369,"insertUser":{"userID":150369,"name":"v.winters","url":"https:\/\/community.smartsheet.com\/profile\/v.winters","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!p_DnqRu23us!e98n5_-JJOs!fH1r3mTuHpU","dateLastActive":"2023-06-28T16:34:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":150369,"lastUserID":150369,"lastUser":{"userID":150369,"name":"v.winters","url":"https:\/\/community.smartsheet.com\/profile\/v.winters","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!p_DnqRu23us!e98n5_-JJOs!fH1r3mTuHpU","dateLastActive":"2023-06-28T16:34:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3375939165,"url":"https:\/\/community.smartsheet.com\/discussion\/107030\/how-to-subtract-percentages","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107030\/how-to-subtract-percentages","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":107030,"commentID":382885,"name":"Re: How to subtract percentages?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382885#Comment_382885","dateInserted":"2023-06-28T16:35:48+00:00","insertUserID":150369,"insertUser":{"userID":150369,"name":"v.winters","url":"https:\/\/community.smartsheet.com\/profile\/v.winters","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!p_DnqRu23us!e98n5_-JJOs!fH1r3mTuHpU","dateLastActive":"2023-06-28T16:34:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-28T16:35:51+00:00","dateAnswered":"2023-06-28T16:31:26+00:00","acceptedAnswers":[{"commentID":382883,"body":"
@v.winters<\/a> <\/p> If the two percent columns are formatted as percent columns (see screenshot), then the % Not Complete column would have this formula: <\/p> =1 - [%Complete]<\/em>@row<\/p> Hope this helps!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":107019,"type":"question","name":"Data Mesh Run Immediately","excerpt":"I saw a post from 2019 stating that the Run Immediately wasn't working and someone responded that there were issues. Was this resolved? I see the original question is from 2019 but when I tried using \"Immediately\" today it doesn't seem to run either. I was hoping to use \"Immediately\" as a run time since the person who owns…","snippet":"I saw a post from 2019 stating that the Run Immediately wasn't working and someone responded that there were issues. Was this resolved? I see the original question is from 2019…","categoryID":343,"dateInserted":"2023-06-28T14:24:46+00:00","dateUpdated":"2023-06-28T14:53:46+00:00","dateLastComment":"2023-06-28T17:13:57+00:00","insertUserID":120231,"insertUser":{"userID":120231,"name":"Pamela Wagner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pamela%20Wagner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-28T17:01:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":91566,"lastUserID":124290,"lastUser":{"userID":124290,"name":"Adriane Price","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Adriane%20Price","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BmjXAS9m9aY!oUjUqI9WkTY!3brbJb9YCMB","dateLastActive":"2023-06-28T17:17:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":21,"score":null,"hot":3375936523,"url":"https:\/\/community.smartsheet.com\/discussion\/107019\/data-mesh-run-immediately","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107019\/data-mesh-run-immediately","format":"Rich","lastPost":{"discussionID":107019,"commentID":382913,"name":"Re: Data Mesh Run Immediately","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382913#Comment_382913","dateInserted":"2023-06-28T17:13:57+00:00","insertUserID":124290,"insertUser":{"userID":124290,"name":"Adriane Price","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Adriane%20Price","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BmjXAS9m9aY!oUjUqI9WkTY!3brbJb9YCMB","dateLastActive":"2023-06-28T17:17:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-28T17:04:09+00:00","dateAnswered":"2023-06-28T16:59:56+00:00","acceptedAnswers":[{"commentID":382898,"body":" @Pamela Wagner<\/a> - Hello<\/p> The column mapping you setup in the DataMesh configuration is used to determine what information needs to link or copy and where it needs to go. The Execution Frequency<\/strong> is what tells the system when to run the DataMesh workflow.<\/p> Execution Frequency: Scheduled execution frequency to update DataMesh values.<\/p> The Update Immediately<\/em> execution frequency isn't supported when using a report as your source. If using a report this could be why you are not seeing updates immediately.<\/p> As far as what triggers a workflow to run when \"Update Immediately\" is selected, DataMesh looks for matching cell values and these could come from manual entries, formulas, or cell links. When there is a successful mesh you can see the CONFIG LOGS by clicking the paper icon.<\/p> After clicking the paper icon a CONFIG LOGS window will pop up showing a history of all the successful and errors.<\/p>![\"Menu.PNG\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/CAZC0IAD3A4B\/menu-png.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"Screenshot](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/KGDIFS874DA3\/screenshot-2023-06-28-105433.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/H8M3P40BH8RP\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
