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.

Smartsheet slow response

DanS
DanS ✭✭
edited 12/09/19 inArchived 2017 Posts

Hi,

I would like to know if you are also experiencing that Smartsheet is slow today (Sept. 21, 2017 - GMT+8)

Thanks

Tags:
· Share on Facebook Share on Twitter

Comments

This discussion has been closed.

Categories

I finally found the correct formula:<\/p>

=SUMIF([Part number]$185:[Part number]$369, CONTAINS([Part number]167, @cell), Quantity$185:Quantity$369)<\/code><\/strong><\/p>

Like that it is working partially, because as I have sub assemblies, I will need to take the quantity of the PARENT() and multiply it to have the correct value.<\/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":106651,"type":"question","name":"Incorrect Argument Set with nested IF","excerpt":"Counting number of occurances where month\/year is 1\/23 AND where cell within the row does not contain \"Color Add\" =COUNTIFS({New Product Status (Imagen) Go Live Launch Date}, IFERROR(MONTH(@cell), 0) = 5, {New Product Status (Imagen) Go Live Launch Date}, IFERROR(YEAR(@cell), 0) = 2023, {New Product Status (Imagen) new or…","categoryID":322,"dateInserted":"2023-06-20T18:01:37+00:00","dateUpdated":"2023-06-20T19:20:48+00:00","dateLastComment":"2023-06-21T13:22:46+00:00","insertUserID":74386,"insertUser":{"userID":74386,"name":"Stephanie Kiecker","url":"https:\/\/community.smartsheet.com\/profile\/Stephanie%20Kiecker","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!W2nUX5neWjw!6djX-omKb7Q!x0GPDTlMr6q","dateLastActive":"2023-06-21T13:31:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":74386,"lastUserID":150413,"lastUser":{"userID":150413,"name":"Kleerfyre","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kleerfyre","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0FA9VDUULUEH\/n4HMXW6FGST3I.jpg","dateLastActive":"2023-06-21T13:21:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":34,"score":null,"hot":3374639663,"url":"https:\/\/community.smartsheet.com\/discussion\/106651\/incorrect-argument-set-with-nested-if","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106651\/incorrect-argument-set-with-nested-if","format":"Rich","lastPost":{"discussionID":106651,"commentID":381471,"name":"Re: Incorrect Argument Set with nested IF","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381471#Comment_381471","dateInserted":"2023-06-21T13:22:46+00:00","insertUserID":150413,"insertUser":{"userID":150413,"name":"Kleerfyre","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kleerfyre","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0FA9VDUULUEH\/n4HMXW6FGST3I.jpg","dateLastActive":"2023-06-21T13:21:43+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-21T11:33:23+00:00","dateAnswered":"2023-06-20T20:32:28+00:00","acceptedAnswers":[{"commentID":381387,"body":"

The @cell part at the end is wrong. It will need to be @cell = \"Color Add\", but in doing that, you will need to adjust your NOT(CONTAINS part. Try replacing it with NOT(@cell = \"Color Add\")<\/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":106654,"type":"question","name":"I cannot get the jira connector to work","excerpt":"I have a business account. I am an Admin in Jira. There is nothing telling me how to connect. When I click on connect it tells me to contact SmartSheet. I had an account manager. Cant find his name. Can't seem to put in a support ticket either.","categoryID":343,"dateInserted":"2023-06-20T18:25:35+00:00","dateUpdated":"2023-06-21T11:24:59+00:00","dateLastComment":"2023-06-21T12:52:23+00:00","insertUserID":159164,"insertUser":{"userID":159164,"name":"clawson","url":"https:\/\/community.smartsheet.com\/profile\/clawson","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtd8k6WqAcj3CUkjC0jOTaQM0V6AiPZO2dYG7Ihh=s96-c","dateLastActive":"2023-06-21T12:52:51+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-21T13:32:05+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":21,"score":null,"hot":3374638078,"url":"https:\/\/community.smartsheet.com\/discussion\/106654\/i-cannot-get-the-jira-connector-to-work","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106654\/i-cannot-get-the-jira-connector-to-work","format":"Rich","lastPost":{"discussionID":106654,"commentID":381467,"name":"Re: I cannot get the jira connector to work","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381467#Comment_381467","dateInserted":"2023-06-21T12:52:23+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-21T13:32:05+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-21T12:54:58+00:00","dateAnswered":"2023-06-21T12:52:23+00:00","acceptedAnswers":[{"commentID":381467,"body":"

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

The Jira Connector would need to be purchased in addition to your Smartsheet plan. If your plan doesn't include this connector, you can contact the Sales team from this page. <\/a><\/p>

Here's more information: Smartsheet for Jira Connector: Overview<\/a><\/p>

Cheers,<\/p>

Genevieve<\/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":[]}],"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

  • Make sum of one column in function of value of another

    Hello everybody, I did not find my answer in the different discussions, then I hope you will be able to help me. I have a smart sheet with 2 columns: Part number Quantity I would like to count the total of parts with a certain number. Finally, it is an addition of the quantity when the P/N is equal to a certain value. I…

  • Incorrect Argument Set with nested IF

    Counting number of occurances where month/year is 1/23 AND where cell within the row does not contain "Color Add" =COUNTIFS({New Product Status (Imagen) Go Live Launch Date}, IFERROR(MONTH(@cell), 0) = 5, {New Product Status (Imagen) Go Live Launch Date}, IFERROR(YEAR(@cell), 0) = 2023, {New Product Status (Imagen) new or…

  • I cannot get the jira connector to work

    I have a business account. I am an Admin in Jira. There is nothing telling me how to connect. When I click on connect it tells me to contact SmartSheet. I had an account manager. Cant find his name. Can't seem to put in a support ticket either.