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.

External clients access to view worksheets

I have created a project program which our client was able to view, however she now needs a"Log-on" & Password to be able to view my sheet. I haven't changed any settings, so I need help to let her view the project program?

Comments

  • Heidi Decker
    Heidi Decker ✭✭✭✭✭✭

    Hi Peter,

    Did you share the sheet with your client using the share button at the bottom of the sheet? This would send the client an email with a link to your sheet. When they first try to access it, they will be prompted to set up a log on and password.

    Hope this helps,

    Peace!

  • She had been using it for about 2 months, then the password option just appeared.

  • Hi Peter-- It's possible that she logged in using Google or Office365--either of these authentication options will eventually expire and be renewed. It's also possible that she did create a log in and password two months ago and has just been logged in since then. Sometimes a browser upgrade or clearing your history can log you out of sites like Smartsheet. Either way, if you shared the sheet with her using the Sharing link at the bottom of the sheet, she will need to log in to Smartsheet to view the sheet. This does not require her to pay for anything or to have any kind of subscription.

    If you do not want her to log in, you could publish the sheet using the Publish tab at the bottom of the sheet, however this is a little less secure, as it will allow anyone with the link to view the sheet.

  • Tony Davidson - SmartSheet Certified User 2016
    edited 07/31/16

    我utili发布链接与外部客户s I do not want them to have access to my workspace and this works just fine.

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Tony,

    There is also sheet-level sharing now where you can share one sheet in the workspace with a different user or an existing shared user with a higher privilege.

    Craig

  • Thanks Craig! I will definitely test that out! Tony

This discussion has been closed.
Incorporate the below into your formula it will give you the Monday following the last completed date.<\/p>

=[Completed Date]@row - (WEEKDAY([Completed Date]@row) - 2)+7<\/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":106620,"type":"question","name":"Need empty column blank","excerpt":"I want to use a formula like this below but if there is no date in the other column to add +14 to, then leave row blank. =([CONFIRM OW PHOTO DUE]@row + 14) Need the \"14\" left blank","categoryID":322,"dateInserted":"2023-06-20T00:19:06+00:00","dateUpdated":null,"dateLastComment":"2023-06-20T13:08:17+00:00","insertUserID":162246,"insertUser":{"userID":162246,"name":"Shawn_K2","url":"https:\/\/community.smartsheet.com\/profile\/Shawn_K2","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nPFlXyflhuI!uj8vZ9JIm_o!1axowkoO9t8","dateLastActive":"2023-06-20T13:11:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162246,"lastUser":{"userID":162246,"name":"Shawn_K2","url":"https:\/\/community.smartsheet.com\/profile\/Shawn_K2","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nPFlXyflhuI!uj8vZ9JIm_o!1axowkoO9t8","dateLastActive":"2023-06-20T13:11:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":56,"score":null,"hot":3374489843,"url":"https:\/\/community.smartsheet.com\/discussion\/106620\/need-empty-column-blank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106620\/need-empty-column-blank","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106620,"commentID":381282,"name":"Re: Need empty column blank","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381282#Comment_381282","dateInserted":"2023-06-20T13:08:17+00:00","insertUserID":162246,"insertUser":{"userID":162246,"name":"Shawn_K2","url":"https:\/\/community.smartsheet.com\/profile\/Shawn_K2","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nPFlXyflhuI!uj8vZ9JIm_o!1axowkoO9t8","dateLastActive":"2023-06-20T13:11:30+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/BW38GVCJFDPD\/2023-06-19-20-16-43-creative-ops-comprehensive-content-tracker-smartsheet-com.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"2023-06-19 20_16_43-Creative Ops - Comprehensive Content Tracker - Smartsheet.com.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-20T13:11:28+00:00","dateAnswered":"2023-06-20T12:13:43+00:00","acceptedAnswers":[{"commentID":381259,"body":"

=If([Confirm OW Photo Due]@row=\"//www.santa-greenland.com/community/discussion/5568/\",\"//www.santa-greenland.com/community/discussion/5568/\",[Confirm OW Photo Due]@row+14)<\/p>"},{"commentID":381278,"body":"

Hi @Shawn_K2<\/a> <\/p>

@Hollie Green<\/a>'s formula should work. I wrote the same one before realizing that Hollie already provided an answer 😀<\/span><\/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":106616,"type":"question","name":"Groups - how many users in a group?","excerpt":"The help files indicates you can bulk upload 1,000 emails to a group. Is that the maximum number of users that can be in a group? I could not find documentation indicating how many users could be in a group. TIA","categoryID":321,"dateInserted":"2023-06-19T21:51:09+00:00","dateUpdated":"2023-06-20T08:19:00+00:00","dateLastComment":"2023-06-20T09:36:32+00:00","insertUserID":15741,"insertUser":{"userID":15741,"name":"ker9","url":"https:\/\/community.smartsheet.com\/profile\/ker9","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-20T11:01:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-20T13:38:35+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":25,"score":null,"hot":3374465861,"url":"https:\/\/community.smartsheet.com\/discussion\/106616\/groups-how-many-users-in-a-group","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106616\/groups-how-many-users-in-a-group","format":"Rich","tagIDs":[442],"lastPost":{"discussionID":106616,"commentID":381246,"name":"Re: Groups - how many users in a group?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381246#Comment_381246","dateInserted":"2023-06-20T09:36:32+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-20T13:38:35+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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-20T11:01:39+00:00","dateAnswered":"2023-06-20T09:36:32+00:00","acceptedAnswers":[{"commentID":381246,"body":"

Hi @ker9<\/a> <\/p>

That limit is specific to bulk-uploading the emails into the group, to ensure that the request is processed successfully. I don't believe there's currently a hard limit for the number of users that can be in a group. I have seen some groups with around 10,000 contacts, if that helps. <\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts