Users having issues with accessing published sheets

Carol-Anne Cerbone

嗨

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.

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.

Hi Community, <\/p>

On June 28, 2023, Smartsheet will be migrating away from the deprecated Azure Active Directory (AD) Graph service to the new Microsoft Graph service.<\/p>

What this means for you:<\/strong> 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.<\/p>

If you are an Azure Administrator:<\/strong><\/p>

1. You 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. <\/li>
2. 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"<\/li><\/ol>

   Please note: <\/strong><\/p>

   1. You 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.<\/li>
   2. 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.<\/li><\/ol>

      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.<\/p>

      To see the Microsoft announcement regarding the deprecation of the Azure AD Graph service, click here<\/a>. 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. <\/p>

      Best regards,<\/p>

      The Smartsheet Product Team<\/p>

      Product screenshots<\/em><\/strong><\/p>

      1. Permissions request form for Azure administrators:<\/em><\/p>

      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\\\"//m.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-08-19T00:38:55+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

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.

Hi Community, <\/p>

On June 28, 2023, Smartsheet will be migrating away from the deprecated Azure Active Directory (AD) Graph service to the new Microsoft Graph service.<\/p>

What this means for you:<\/strong> 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.<\/p>

If you are an Azure Administrator:<\/strong><\/p>

1. You 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. <\/li>
2. 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"<\/li><\/ol>

   Please note: <\/strong><\/p>

   1. You 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.<\/li>
   2. 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.<\/li><\/ol>

      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.<\/p>

      To see the Microsoft announcement regarding the deprecation of the Azure AD Graph service, click here<\/a>. 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. <\/p>

      Best regards,<\/p>

      The Smartsheet Product Team<\/p>

      Product screenshots<\/em><\/strong><\/p>

      1. Permissions request form for Azure administrators:<\/em><\/p>

      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\\\"//m.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-08-19T00:38:55+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

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.