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.

expired trial to member of team plan

i apologize in advance if this was asked before, but i didn't find it in the forum yet.

i have a user that was on a trial to gain access to a sheet that she is one of many users of this particular sheet. Her trial expired and i sent her an invite (used her same email address) from our team account, but it was not as a licensed user. When she logged in she appeared to have access to all the same sheets... i took that as a win.

Today, she is trying to modify information in one of the sheets and has a message saying "you can access this feature when you upgrade your account".

did i do something wrong, to the best of my knowledge she is not an "owner" of this sheet. I can verify her "account" is active.

Smartsheet has "exploded" here and this is only the first user that i've invited that had a trial account, and i'm afraid of future issues similar to this as i know i have other users on expiring trials.

Comments

  • Hi James,

    if are you now managing a team or enterprise account and want them to join your account, the they will need to terminate their trial first before accepting your invitation.

    From Smartsheet Help:

    1. - Click Account > Account Admin > Plan & Billing Info.
    2. - Click Cancel Account. The Cancel Account form appears.
    3. - Select "Cancel Account": Immediately deletes the sheets you own and completely closes your account, preventing you from logging back in.
    4. - Click OK. A confirmation message appears.
    5. - Click OK.

    I went along the same road, because I wanted to get people quickly to try Smartsheet without all that admin stuff ;-)

    我不确定如果我记得正确的,但我认为一次thy joined, you need to reassign them to the sheets/tasks/worklplaces.

    Best regards

    Stefan

  • Travis
    Travis Employee
    edited 12/04/15

    Hi James, all users regardless of their plan type or status (free/paid/trial/etc) can be shared to and edit sheets owned by paid users.

    You mentioned you added the user to your team as a non-licensed user. As Stefan mentioned, they need to accept the invitation before they are members of you team but this will not affect their ability to be shared to and edit sheets shared to them by paid users. It is also not necessary for her to cancel her trial account, because her trial already expired.

    Here are a couple possibilities why they cannot edit the sheet in question:

    -It is owned by her (non-licensed user). Free (non-licensed users) cannot own or create sheets. Any sheet she created while in her trial will be read only unless it is transferred to a paid user or she is given a license.

    她试图改变以前的表ved for paid users only. Structural changes such as adding/removing columns, changing column properties, creating webforms, etc are only available for paid users.

    Here is more information on non-licensed users and what they have access to:http://help.smartsheet.com/customer/en/portal/articles/520100-user-types#nonlicensed

  • James Zurwell
    edited 12/04/15

    thx for the update... today has been a day of crisis on other fronts..... i was able to pull a report of all the smartsheets in use under the Team account. As of the end of the day 12/1/ 15, she is listed as an admin for this sheet. At that time, she was was closing in on the end of her trial.

    i beleive i sent her the invite on 12/2 and that is when she could not modify the sheet. I have since confirmed what she wanted to do, which was modify information in a drop down box on the sheet. Due to the multiple crisis' of the day, i have not had a chance to pull a report and see if she is still listed as an admin of this particular sheet. I'm hoping to do that soon....

    the owner of this particluar sheet is is on our team account and a licensed user.

    i'm hoping this follow up information helps.

  • Travis
    Travis Employee

    James, from your explanation it sounds like she was added as a free (non-licensed) member to your account, correct? Free users cannot make structural changes to sheets which includes changing column properties. Because of this, she cannot modify the predetermined values in a Dropdown List. Giving her a license will enable this and other features for her.

    Let me know if you still have questions on this. Thanks!

This discussion has been closed.
This has to do with how a milestone is represented (ie. a 0 day duration). If you hard type milestone without a predecessor or successor, it will show up as the beginning of that day instead of the end of the day. If you have a milestone that is following a standard finish to start logic, it will show up at the end of the previous activity. <\/p>

So, Task B4 in the backwards version is actually saying that the completion happened in the 00:00 hr of that day. if you put any activity in that has a duration and uses the start to finish relationship, that activity will naturally finish at the end of the previous day. So, to get your example above to work, the finishing task would need to be 1 day long so it takes up the full work day. I found it easier to visualize if you zoom all the way in on the gantt chart so you can see the diamond symbol of the milestone at the beginning and end of the days when used in different set ups.<\/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":[]},{"discussionID":108291,"type":"question","name":"Conditional formatting in Gantt not working with dependencies","excerpt":"For some reason it seems like my conditional formatting rules aren't being applied to certain rows in the Gantt chart side of this sheet. The problem is resolved if I disable dependencies, but I need those and don't understand why this should matter since I don't have any rules related to status or % complete in the…","snippet":"For some reason it seems like my conditional formatting rules aren't being applied to certain rows in the Gantt chart side of this sheet. The problem is resolved if I disable…","categoryID":321,"dateInserted":"2023-07-29T22:50:55+00:00","dateUpdated":null,"dateLastComment":"2023-07-30T15:38:08+00:00","insertUserID":164323,"insertUser":{"userID":164323,"name":"smbailey","title":"Senior Business Systems Analyst","url":"https:\/\/community.smartsheet.com\/profile\/smbailey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-30T15:36:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":164323,"lastUser":{"userID":164323,"name":"smbailey","title":"Senior Business Systems Analyst","url":"https:\/\/community.smartsheet.com\/profile\/smbailey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-30T15:36:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":30,"score":null,"hot":3381404343,"url":"https:\/\/community.smartsheet.com\/discussion\/108291\/conditional-formatting-in-gantt-not-working-with-dependencies","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108291\/conditional-formatting-in-gantt-not-working-with-dependencies","format":"Rich","tagIDs":[219,319,437,439],"lastPost":{"discussionID":108291,"commentID":387971,"name":"Re: Conditional formatting in Gantt not working with dependencies","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387971#Comment_387971","dateInserted":"2023-07-30T15:38:08+00:00","insertUserID":164323,"insertUser":{"userID":164323,"name":"smbailey","title":"Senior Business Systems Analyst","url":"https:\/\/community.smartsheet.com\/profile\/smbailey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-30T15:36:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/4N6Y1NCLVR43\/2023-07-29-15-46-58-281-29-moving-plan-smartsheet-com.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"2023-07-29 15_46_58-(1) Moving plan - Smartsheet.com.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-30T15:39:24+00:00","dateAnswered":"2023-07-30T09:21:36+00:00","acceptedAnswers":[{"commentID":387967,"body":"

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

I hope you're well and safe!<\/p>

I can't see any rows in your screenshot that should be colored differently. Parent rows can't be changed.<\/p>

Can you share more screenshots with the conditional formatting options used on a few child rows?<\/strong> (Delete\/replace any confidential\/sensitive information before sharing) That would make it easier to help. <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic weekend!<\/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":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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"}]},{"discussionID":108284,"type":"question","name":"Cross referencing same range across multiple sheets","excerpt":"I am using one sheet, call it Program Data, as my source data for piping into my many Project Sheets. The Project Sheets have a Project ID in one cell that determines which line of the Program Data sheet to call out (e.g. Start Date, Team Lead 1, Team Lead 2, Team Lead 3, ...). I can't find a way to link each cell without…","snippet":"I am using one sheet, call it Program Data, as my source data for piping into my many Project Sheets. The Project Sheets have a Project ID in one cell that determines which line…","categoryID":321,"dateInserted":"2023-07-28T22:46:52+00:00","dateUpdated":null,"dateLastComment":"2023-07-31T13:25:17+00:00","insertUserID":164283,"insertUser":{"userID":164283,"name":"Gary S","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Gary%20S","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-31T13:32:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-31T15:50:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3381395529,"url":"https:\/\/community.smartsheet.com\/discussion\/108284\/cross-referencing-same-range-across-multiple-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108284\/cross-referencing-same-range-across-multiple-sheets","format":"Rich","tagIDs":[334,446,472],"lastPost":{"discussionID":108284,"commentID":388018,"name":"Re: Cross referencing same range across multiple sheets","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388018#Comment_388018","dateInserted":"2023-07-31T13:25:17+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-31T15:50:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-31T13:32:38+00:00","dateAnswered":"2023-07-31T13:25:17+00:00","acceptedAnswers":[{"commentID":388018,"body":"

It is not possible to transfer cross sheet references from one sheet to another already existing sheet. Feel free to submit an enhancement request using the \"Product Ideas\" tab at the top of this sheet.<\/p>


<\/p>

If you have created these cross sheet references and then \"save as new\" the project sheet, the cross sheet references will copy over as well. It is just transferring them to an already existing sheet that isn't possible.<\/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":334,"urlcode":"automations","name":"Automations"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}]}],"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