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.

Enterprise video?

Loann McGee
Loann McGee ✭✭✭✭✭✭
edited 12/09/19 inArchived 2015 Posts

Good morning,

I did a search in the online videos on demand, but didn't find one. I'm looking for a video that gives a fairly in-depth look at what the Enterprise features are and how this is of greater benefit.

Our IT dept is concerned that they would need to be our go-to for help regarding Smartsheet, and I'd like to equip them with a very detailed view of what they would/would not have to take on in the Enterprise aspect.

Currently, as a Team, our IT dept needs to know very little of the actual Smartsheet program. They are just the appovers for areas that are wanting to come on board.

Blessings,

Loann

Comments

  • I'm interested in knowing more about the differences between Team and Enterprise as well.

  • Travis
    Travis Employee

    Hi Loann! The sales team would be the best resource for information on Enterprise accounts and the difference between Team and Enterprise. You can email them at[email protected]

    As far as your specific question about getting your IT department involved... it would depend on what you want to do with your account. For example, if you wanted to set up SAML SSO (single sign on) then that would require some effort from your IT group. One of the benefits of an Enterprise plan is that they all have a dedicated Customer Success Manager from Smartsheet to help wherever needed. If there is work that needs to be done by your IT department, your CSM can help with that process.

    Here is some information on the Enterprise plan://www.santa-greenland.com/enterprise

  • Loann McGee
    Loann McGee ✭✭✭✭✭✭
    edited 09/14/15

    Thank you, Travis. I know one of their concerns is that the IT Help Desk would be fielding questions on how to create reports, sheets, formulas, Gantt, etc. in Smartsheet.

    We're still a ways out from getting to the Enterprise level, but like to be well informed. I was hoping for a video to help contrast/compare. I'll connect with the sales team!

    Blessings,

    Loann

  • Tim Meeks
    Tim Meeks ✭✭✭✭✭✭
    edited 09/15/15

    Loann,

    I serve as the SS system admin for our agency, and I am not in the IT Help Desk area, and our IT Help desk does NOT field questions from our SS users.

    I am in the IT area as a project manager and part of my role as an embedded contractor is to field SS questions from users. So one idea would be to get someone that is a technical person to serve in this role that is not in the IT Help Desk area.

    其中一个原因,我没有完全依赖IT is that we do not use the SAML SSO (single sign on) feature. But, I have had to engage our network team to see about utilizing the User Auto Provisioning function (which they have yet to get back with me onFrown.)

    Here's how we handle the user questions/support issues:

    1) As Travis said, one huge advantage of the enterprise account is havinga dedicated CSM. Our CSM (ShaneCool) is agreat resourceand takes both my email and phone calls and has done team training for us. I will have users contact me and then I will contact support or our CSM.

    2) TheSS Online Helpis great tool, as you know, and I point users to that as their first option.

    3) We have 3-4employeeshere that have becomeexpertsin their use of SS and we go to them for solutions.

    4) TheSS Community(you being one!) is a HUGE help for me as a sys admin to find/post answers.

    5) For the first 6 months of SS being rolled out, we had amonthly Lunch and Learn sessionwhere either an expert user showed how they had integrated SS or our SS CSM did training and answered questions.

    Hope that helps alleviate some concern of needing your IT Help Desk to field SS questions.

    Tim

  • Loann McGee
    Loann McGee ✭✭✭✭✭✭
    edited 09/15/15

    Great input, Tim!! I'm the unofficial Smartsheet "Queen" here at work - and I love helping others learn about SS for the first time, or to help troubleshoot.

    Thanks for the input on how it works on your end, and that I can alleviate the concerns for our IT Help Desk. ;-)

    Blessings,

    Loann

This discussion has been closed.
Hi there,<\/p>

I think this should work:<\/p>

=IF(COUNTIF(Referencia:Referencia, Referencia@row) > 1, 1)<\/p>

Have a great day.<\/p>

Matt<\/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":107888,"type":"question","name":"Filter distinct values only into new column","excerpt":"Hello! I have a column that consists of rows with values, some that differ and some that repeat [(Cells Linked from TE Tracker)], I want the next column over \"Distinct\" to only give me the unique values of [(Cells Linked from TE Tracker)] From what I've seen, there is no direct function that can do this, but has anyone…","snippet":"Hello! I have a column that consists of rows with values, some that differ and some that repeat [(Cells Linked from TE Tracker)], I want the next column over \"Distinct\" to only…","categoryID":322,"dateInserted":"2023-07-20T22:29:01+00:00","dateUpdated":null,"dateLastComment":"2023-07-22T20:06:16+00:00","insertUserID":163466,"insertUser":{"userID":163466,"name":"sawuzie","url":"https:\/\/community.smartsheet.com\/profile\/sawuzie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-22T20:06:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":163466,"lastUser":{"userID":163466,"name":"sawuzie","url":"https:\/\/community.smartsheet.com\/profile\/sawuzie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-22T20:06:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":39,"score":null,"hot":3379950317,"url":"https:\/\/community.smartsheet.com\/discussion\/107888\/filter-distinct-values-only-into-new-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107888\/filter-distinct-values-only-into-new-column","format":"Rich","lastPost":{"discussionID":107888,"commentID":386542,"name":"Re: Filter distinct values only into new column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386542#Comment_386542","dateInserted":"2023-07-22T20:06:16+00:00","insertUserID":163466,"insertUser":{"userID":163466,"name":"sawuzie","url":"https:\/\/community.smartsheet.com\/profile\/sawuzie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-22T20:06:45+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":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-22T05:31:23+00:00","dateAnswered":"2023-07-21T02:06:24+00:00","acceptedAnswers":[{"commentID":386312,"body":"

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


<\/p>

There's no direct way to do this. However, you can add a checkbox helper column to identify duplicates. You can use the formula =IF(COUNTIF([Cells Linked from TE Tracker]:[Cells Linked from TE Tracker], [Cells Linked from TE Tracker]@row) > 1, 1, 0). This will add a check in the duplicates column for all values which appear more than once. You can then add the Distinct column with the formula =IF([Duplicate]@row=0, [Cells Linked from TE Tracker]@row). The Distinct column will only have the distinct values listed.<\/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":107937,"type":"question","name":"True\/False formula?","excerpt":"I'm trying to figure out a formula to note a \"1\" in the cell if the information in the cell next to it is a certain value, any other value needs to show a \"0\". Is this a \"true\/false\" formula? I figured this out: =IF([Question 1]@row = \"2. I should avoid using the electronic device during the initial connection; however,…","snippet":"I'm trying to figure out a formula to note a \"1\" in the cell if the information in the cell next to it is a certain value, any other value needs to show a \"0\". Is this a…","categoryID":321,"dateInserted":"2023-07-21T20:52:02+00:00","dateUpdated":"2023-07-21T20:53:35+00:00","dateLastComment":"2023-07-21T21:06:17+00:00","insertUserID":159988,"insertUser":{"userID":159988,"name":"Jillian M","url":"https:\/\/community.smartsheet.com\/profile\/Jillian%20M","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bR_Ym_nhTvw!oRnZKN3xkb4!GGy8kNscpSH","dateLastActive":"2023-07-21T21:16:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":159988,"lastUserID":159988,"lastUser":{"userID":159988,"name":"Jillian M","url":"https:\/\/community.smartsheet.com\/profile\/Jillian%20M","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bR_Ym_nhTvw!oRnZKN3xkb4!GGy8kNscpSH","dateLastActive":"2023-07-21T21:16:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":31,"score":null,"hot":3379948099,"url":"https:\/\/community.smartsheet.com\/discussion\/107937\/true-false-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107937\/true-false-formula","format":"Rich","lastPost":{"discussionID":107937,"commentID":386520,"name":"Re: True\/False formula?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386520#Comment_386520","dateInserted":"2023-07-21T21:06:17+00:00","insertUserID":159988,"insertUser":{"userID":159988,"name":"Jillian M","url":"https:\/\/community.smartsheet.com\/profile\/Jillian%20M","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bR_Ym_nhTvw!oRnZKN3xkb4!GGy8kNscpSH","dateLastActive":"2023-07-21T21:16:17+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-21T20:55:47+00:00","dateAnswered":"2023-07-21T20:53:49+00:00","acceptedAnswers":[{"commentID":386517,"body":"

@Jillian M<\/a> an IF statement will do what you need.<\/p>

=if([Column Name]@row=\"Value\",1,0)<\/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":[]}],"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