Users having issues with accessing published sheets
嗨
I have had several users reach out to me indicating they are no longer able to access a published sheet. They have been able to access in the past but now they are not. Nothing has changed with these published. Yesterday for one user, I deleted their account and re-added. Once he accepted the invitation, he was able to access the sheet. This morning he is having issues again. Below is a screen shot of what he is experiencing. Does anyone have any thoughts on what might be going on. He isn't the only user that is currently experiencing this issue.
Best Answer
-
Paul Newcome ✭✭✭✭✭✭Does your company use Single Sing-On? There were some updates that took affect yesterday. I wonder if maybe that is affecting things since it seems to be an issue with being part of the company's account.
thinkspi.com
Answers
-
Paul Newcome ✭✭✭✭✭✭
Does your company use Single Sing-On? There were some updates that took affect yesterday. I wonder if maybe that is affecting things since it seems to be an issue with being part of the company's account.
thinkspi.com
-
Carol-Anne Cerbone ✭✭✭✭✭
@Paul Newcome- we do use SSO and I suspect that is the issue. Thank you for the information.
-
Paul Newcome ✭✭✭✭✭✭
Sorry I couldn't fix it for you, but hopefully that gets you pointed in the right direction to get it fixed.
thinkspi.com
Categories
You need to remove the closing parenthesis from before the comma.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":107142,"type":"question","name":"Dynamic View not allowing editable field","excerpt":"Hi, I have 2 fields in my Dynamic View that are built exactly the same way. One is showing as Read Only and the other Required. They both need to be Required. Anyone else having this issue? I just built this last week and was working correctly until today.","snippet":"Hi, I have 2 fields in my Dynamic View that are built exactly the same way. One is showing as Read Only and the other Required. They both need to be Required. Anyone else having…","categoryID":343,"dateInserted":"2023-06-30T15:30:52+00:00","dateUpdated":null,"dateLastComment":"2023-06-30T16:08:48+00:00","insertUserID":116932,"insertUser":{"userID":116932,"name":"Darla Brown","title":"Executive Assistant\/Smartsheet Nerd","url":"https:\/\/community.smartsheet.com\/profile\/Darla%20Brown","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2ijXPwm027Q!unNWp2GmkrQ!CBVsVJExguI","dateLastActive":"2023-06-30T18:53:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-01T17:02:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":21,"score":null,"hot":3376282180,"url":"https:\/\/community.smartsheet.com\/discussion\/107142\/dynamic-view-not-allowing-editable-field","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107142\/dynamic-view-not-allowing-editable-field","format":"Rich","lastPost":{"discussionID":107142,"commentID":383352,"name":"Re: Dynamic View not allowing editable field","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383352#Comment_383352","dateInserted":"2023-06-30T16:08:48+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-01T17:02:07+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/5JPTRQJ4FVMN\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-30T16:04:54+00:00","dateAnswered":"2023-06-30T15:49:28+00:00","acceptedAnswers":[{"commentID":383344,"body":"
Hi @Darla Brown<\/a> <\/p> I hope you're well and safe!<\/p> Has anything in the sheet changed? Any formulas in the cells? <\/p> I hope that helps!<\/p> Be safe, and have a fantastic week!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":107125,"type":"question","name":"How to hide certain columns to certain poeple, while unhide to the rest","excerpt":"Hi Dear Community I am sharing my sheet to 2 groups of poeple, for group A they can see the entire sheet, but for group B I would like they to see only part of the columns. Both groups can edit what they can see in the sheet. Is there a way to acheive that? Thanks!","snippet":"Hi Dear Community I am sharing my sheet to 2 groups of poeple, for group A they can see the entire sheet, but for group B I would like they to see only part of the columns. Both…","categoryID":321,"dateInserted":"2023-06-30T09:24:53+00:00","dateUpdated":null,"dateLastComment":"2023-06-30T12:44:32+00:00","insertUserID":162810,"insertUser":{"userID":162810,"name":"流风回雪","url":"https:\/\/community.smartsheet.com\/profile\/%E6%B5%81%E9%A3%8E%E5%9B%9E%E9%9B%AA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-30T11:58:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":139601,"lastUser":{"userID":139601,"name":"jmyzk_cloudsmart_jp","title":"jmyzk","url":"https:\/\/community.smartsheet.com\/profile\/jmyzk_cloudsmart_jp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ZBVD3K8PY0D5\/n7CZ1F4XWEM9Y.JPG","dateLastActive":"2023-07-02T00:56:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":56,"score":null,"hot":3376248565,"url":"https:\/\/community.smartsheet.com\/discussion\/107125\/how-to-hide-certain-columns-to-certain-poeple-while-unhide-to-the-rest","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107125\/how-to-hide-certain-columns-to-certain-poeple-while-unhide-to-the-rest","format":"Rich","lastPost":{"discussionID":107125,"commentID":383311,"name":"Re: How to hide certain columns to certain poeple, while unhide to the rest","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383311#Comment_383311","dateInserted":"2023-06-30T12:44:32+00:00","insertUserID":139601,"insertUser":{"userID":139601,"name":"jmyzk_cloudsmart_jp","title":"jmyzk","url":"https:\/\/community.smartsheet.com\/profile\/jmyzk_cloudsmart_jp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ZBVD3K8PY0D5\/n7CZ1F4XWEM9Y.JPG","dateLastActive":"2023-07-02T00:56:31+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-30T11:59:52+00:00","dateAnswered":"2023-06-30T10:33:48+00:00","acceptedAnswers":[{"commentID":383272,"body":" Hi Dear Andrée Starå<\/strong><\/a><\/p> Thank you so much for your solution!<\/p> It can work, but more like a compromise way. Editing on a report is less convenient.<\/p> It would be better for me to set access right to each column.<\/p> But that can also work for now, thanks a lot.<\/p> By the way are you a BOT?<\/p>"},{"commentID":383283,"body":"
![https:\/\/us.v-cdn.net\/6031209\/uploads\/O8G89VYMG9XL\/consent-flow-azure-admins.png<\/a><\/p>2. Azure consent flow for Azure admins:<\/em><\/p>https:\/\/us.v-cdn.net\/6031209\/uploads\/MFYSUT01EASX\/azure-consent-flow.jpg<\/a><\/p>","bodyRaw":"[{\"insert\":\"Hi Community, \\n\\nOn June 28, 2023, Smartsheet will be migrating away from the deprecated Azure Active Directory (AD) Graph service to the new Microsoft Graph service.\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"What this means for you:\"},{\"insert\":\" If you are attempting to log into Smartsheet using Microsoft Single Sign-On (SSO) on or after June 28, 2023, you will see a one-time permissions request, which you must accept to successfully log in and access your underlying Smartsheet instance. Failure to accept these permissions will result in an unsuccessful login attempt via Microsoft SSO.\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"If you are an Azure Administrator:\"},{\"insert\":\"\\nYou will also be provided with an additional checkbox option to consent to the permissions on behalf of your entire organization. We strongly encourage you to check this box when accepting the new permissions so that others in your organization can continue to access Smartsheet without interruption via Microsoft SSO. \"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"ordered\"}},\"insert\":\"\\n\"},{\"insert\":\"Azure Admins can also grant admin consent for Smartsheet for different enterprise applications directly from Azure. To do so, follow this navigation path: Azure Home > Enterprise Apps > Search for \\\"Smartsheet\\\" > click on \\\"Grant admin consent for Smartsheet\\\"//www.santa-greenland.com/community/discussion/107081/\"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"ordered\"}},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Please note: \"},{\"insert\":\"\\nYou have previously consented to the same permissions for utilizing Microsoft SSO to log into to Smartsheet via the Azure Graph service. We simply need to resurface the consent form because we’re migrating to the new Microsoft Graph service.\"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"ordered\"}},\"insert\":\"\\n\"},{\"insert\":\"You may also be prompted with the permissions request form if you attempt to authenticate into Smartsheet using Microsoft SSO from other third-party apps\\\/integrations. If you encounter this situation, please accept the request to ensure uninterrupted access to your Smartsheet assets.\"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"ordered\"}},\"insert\":\"\\n\"},{\"insert\":\"This change impacts all users utilizing login via Microsoft SSO in Free, Pro, Business, Enterprise, Premier, and legacy plans (Individual, Basic, Advanced - Legacy, Team, and Enterprise - Legacy), including free collaborators, unlicensed users, and Trial users.\\nTo see the Microsoft announcement regarding the deprecation of the Azure AD Graph service, \"},{\"attributes\":{\"link\":\"https:\\\/\\\/learn.microsoft.com\\\/en-us\\\/graph\\\/migrate-azure-ad-graph-overview\"},\"insert\":\"click here\"},{\"insert\":\". We will update this community post when we officially migrate to the Microsoft Graph service. You can also stay informed by subscribing to receive product release updates for curated news of recently released product capabilities and enhancements for the platform of your choosing, delivered to your inbox. As new releases occur, you will receive a weekly email with news of what's released every Tuesday. \\n\\nBest regards,\\nThe Smartsheet Product Team\\n\\n\"},{\"attributes\":{\"italic\":true,\"bold\":true},\"insert\":\"Product screenshots\"},{\"insert\":\"\\n\"},{\"attributes\":{\"italic\":true},\"insert\":\"1. Permissions request form for Azure administrators:\"},{\"insert\":\"\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/O8G89VYMG9XL\\\/consent-flow-azure-admins.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/O8G89VYMG9XL\\\/consent-flow-azure-admins.png\"}},{\"insert\":\"\\n\"},{\"attributes\":{\"italic\":true},\"insert\":\"2. Azure consent flow for Azure admins:\"},{\"insert\":\"\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/MFYSUT01EASX\\\/azure-consent-flow.jpg\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/MFYSUT01EASX\\\/azure-consent-flow.jpg\"}},{\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]","format":"rich","dateInserted":"2023-06-20T22:29:19+00:00","insertUser":{"userID":84306,"name":"Lekshmi Unnithan","url":"https:\/\/community.smartsheet.com\/profile\/Lekshmi%20Unnithan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/05\/52\/n0552fedd1b0dce090ad4b1f50fbd57cd.jpg","dateLastActive":"2023-06-30T20:03:24+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/106673\/important-be-aware-of-upcoming-changes-to-microsoft-sso-one-time-permissions-consent-required","embedType":"quote","name":"[Important] Be aware of upcoming changes to Microsoft SSO (one-time permissions consent required)"}"> https://community.smartsheet.com/discussion/106673/important-be-aware-of-upcoming-changes-to-microsoft-sso-one-time-permissions-consent-required](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/O8G89VYMG9XL\/consent-flow-azure-admins.png\"){kind=link}
![https:\/\/us.v-cdn.net\/6031209\/uploads\/MFYSUT01EASX\/azure-consent-flow.jpg<\/a><\/p>","bodyRaw":"[{\"insert\":\"Hi Community, \\n\\nOn June 28, 2023, Smartsheet will be migrating away from the deprecated Azure Active Directory (AD) Graph service to the new Microsoft Graph service.\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"What this means for you:\"},{\"insert\":\" If you are attempting to log into Smartsheet using Microsoft Single Sign-On (SSO) on or after June 28, 2023, you will see a one-time permissions request, which you must accept to successfully log in and access your underlying Smartsheet instance. Failure to accept these permissions will result in an unsuccessful login attempt via Microsoft SSO.\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"If you are an Azure Administrator:\"},{\"insert\":\"\\nYou will also be provided with an additional checkbox option to consent to the permissions on behalf of your entire organization. We strongly encourage you to check this box when accepting the new permissions so that others in your organization can continue to access Smartsheet without interruption via Microsoft SSO. \"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"ordered\"}},\"insert\":\"\\n\"},{\"insert\":\"Azure Admins can also grant admin consent for Smartsheet for different enterprise applications directly from Azure. To do so, follow this navigation path: Azure Home > Enterprise Apps > Search for \\\"Smartsheet\\\" > click on \\\"Grant admin consent for Smartsheet\\\"//www.santa-greenland.com/community/discussion/107081/\"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"ordered\"}},\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Please note: \"},{\"insert\":\"\\nYou have previously consented to the same permissions for utilizing Microsoft SSO to log into to Smartsheet via the Azure Graph service. We simply need to resurface the consent form because we’re migrating to the new Microsoft Graph service.\"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"ordered\"}},\"insert\":\"\\n\"},{\"insert\":\"You may also be prompted with the permissions request form if you attempt to authenticate into Smartsheet using Microsoft SSO from other third-party apps\\\/integrations. If you encounter this situation, please accept the request to ensure uninterrupted access to your Smartsheet assets.\"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"ordered\"}},\"insert\":\"\\n\"},{\"insert\":\"This change impacts all users utilizing login via Microsoft SSO in Free, Pro, Business, Enterprise, Premier, and legacy plans (Individual, Basic, Advanced - Legacy, Team, and Enterprise - Legacy), including free collaborators, unlicensed users, and Trial users.\\nTo see the Microsoft announcement regarding the deprecation of the Azure AD Graph service, \"},{\"attributes\":{\"link\":\"https:\\\/\\\/learn.microsoft.com\\\/en-us\\\/graph\\\/migrate-azure-ad-graph-overview\"},\"insert\":\"click here\"},{\"insert\":\". We will update this community post when we officially migrate to the Microsoft Graph service. You can also stay informed by subscribing to receive product release updates for curated news of recently released product capabilities and enhancements for the platform of your choosing, delivered to your inbox. As new releases occur, you will receive a weekly email with news of what's released every Tuesday. \\n\\nBest regards,\\nThe Smartsheet Product Team\\n\\n\"},{\"attributes\":{\"italic\":true,\"bold\":true},\"insert\":\"Product screenshots\"},{\"insert\":\"\\n\"},{\"attributes\":{\"italic\":true},\"insert\":\"1. Permissions request form for Azure administrators:\"},{\"insert\":\"\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/O8G89VYMG9XL\\\/consent-flow-azure-admins.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/O8G89VYMG9XL\\\/consent-flow-azure-admins.png\"}},{\"insert\":\"\\n\"},{\"attributes\":{\"italic\":true},\"insert\":\"2. Azure consent flow for Azure admins:\"},{\"insert\":\"\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/MFYSUT01EASX\\\/azure-consent-flow.jpg\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/MFYSUT01EASX\\\/azure-consent-flow.jpg\"}},{\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]","format":"rich","dateInserted":"2023-06-20T22:29:19+00:00","insertUser":{"userID":84306,"name":"Lekshmi Unnithan","url":"https:\/\/community.smartsheet.com\/profile\/Lekshmi%20Unnithan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/05\/52\/n0552fedd1b0dce090ad4b1f50fbd57cd.jpg","dateLastActive":"2023-06-30T20:03:24+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/106673\/important-be-aware-of-upcoming-changes-to-microsoft-sso-one-time-permissions-consent-required","embedType":"quote","name":"[Important] Be aware of upcoming changes to Microsoft SSO (one-time permissions consent required)"}">](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/MFYSUT01EASX\/azure-consent-flow.jpg\"){kind=link}