非营利性的

讨论表

Form Options > Checked 'Enable challenge\/response for additional security' ","categoryID":321,"dateInserted":"2019-10-31T14:03:30+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-01T11:35:15+00:00","insertUserID":109576,"insertUser":{"userID":109576,"name":"Sara@Peer Seattle","url":"https:\/\/community.smartsheet.com\/profile\/Sara%40Peer%20Seattle","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-10\/33\/7e\/n337e9e71c9eb9f8f1ba0a7a1142b41f9.jpg","dateLastActive":"2021-08-23T18:29:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":105321,"lastUser":{"userID":105321,"name":"Brian Parker","url":"https:\/\/community.smartsheet.com\/profile\/Brian%20Parker","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-11-01T11:13:45+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":865,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/61697\/help-enabling-captcha-on-a-form","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/61697\/help-enabling-captcha-on-a-form","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":273,"urlcode":"Security","name":"Security"},{"tagID":281,"urlcode":"Support","name":"Support"}],"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}]},{"discussionID":61546,"type":"discussion","name":"Formula issue for conditional formatting","excerpt":"I am trying to set up a formula to allow for conditional formatting but having some problems. This is the formula I'm trying: =IF([Actual]19 >= [Target]19, IF([Actual]19 < SUM([Target]19 * 0.1), IF([Actual]19 > SUM([Target]19 * 0.1), \"GREEN\", \"AMBER\", \"RED\")) but the result leaves the cell blank with no error message. What…","categoryID":322,"dateInserted":"2019-10-30T09:21:12+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-31T12:40:16+00:00","insertUserID":82626,"insertUser":{"userID":82626,"name":"Faz Mussa","url":"https:\/\/community.smartsheet.com\/profile\/Faz%20Mussa","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-05-05T09:59:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":11072,"lastUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/518\/n0UL39EAWX965.jpg","dateLastActive":"2022-12-01T17:59:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":40,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/61546\/formula-issue-for-conditional-formatting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/61546\/formula-issue-for-conditional-formatting","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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}]},{"discussionID":60611,"type":"discussion","name":"Help with #DIVIDE BY ZERO error message","excerpt":"Hello, Hoping you might be able to assist me with a similar issue I'm experiencing. I've attempted to import a Trello board into Smartsheet for one of my colleagues and I'm getting the same error message, when I view it in grid view on some of the rows. The formula in question that is currently being used…","categoryID":322,"dateInserted":"2019-10-18T06:03:52+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-25T14:49:54+00:00","insertUserID":78206,"insertUser":{"userID":78206,"name":"SteCoxy","url":"https:\/\/community.smartsheet.com\/profile\/SteCoxy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!aTDbGqngcGQ!2wnbf5m83zw!VTDReGCjYpc","dateLastActive":"2022-12-01T12:35:20+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":"2022-12-05T19:12:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":11,"countViews":966,"score":null,"hot":11,"url":"https:\/\/community.smartsheet.com\/discussion\/60611\/help-with-divide-by-zero-error-message","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/60611\/help-with-divide-by-zero-error-message","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-10\/2e\/fa\/2efa87a9e4b4ca6944c8a1effc1c4c0d.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2019-10-17 18.16.09_1.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":209,"urlcode":"Media & Entertainment","name":"Media & Entertainment"},{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":259,"urlcode":"IT & Operations","name":"IT & Operations"},{"tagID":270,"urlcode":"Technology","name":"Technology"},{"tagID":281,"urlcode":"Support","name":"Support"}],"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}]},{"discussionID":59826,"type":"discussion","name":"Dynamic SmartSheets an Option?","excerpt":"First-time poster and amateur SmartSheet user here. I have an existing Excel spreadsheet for our association's Marketing Schedule. Each month has a row and each marketing medium (newsletter, magazine, social media, online ad, etc.) has a column where I list all of the programs and services that will be featured in that…","categoryID":321,"dateInserted":"2019-10-09T14:58:28+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-15T05:54:08+00:00","insertUserID":107041,"insertUser":{"userID":107041,"name":"Jen Burnett","url":"https:\/\/community.smartsheet.com\/profile\/Jen%20Burnett","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-10\/9d\/72\/n9d72174fe2b8820a2225585659ae95aa.jpg","dateLastActive":"2020-05-15T17:52:10+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-12-06T01:03:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":123,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/59826\/dynamic-smartsheets-an-option","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/59826\/dynamic-smartsheets-an-option","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"}],"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}]},{"discussionID":128,"type":"discussion","name":"Show only own tasks in calendar","excerpt":"Hi, I am new to Smartsheet. I already searched for this topic, but wasn't successful. By standard, the calendar in Smartsheet shows all tasks of everybody. I imported the calender into my Google calendar (via ics and directly). There also all tasks of everybody are shown. Is there a way to show only your own tasks (you are…","categoryID":317,"dateInserted":"2015-04-20T13:18:16+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-14T13:59:38+00:00","insertUserID":876,"insertUser":{"userID":876,"name":"Chris","url":"https:\/\/community.smartsheet.com\/profile\/Chris","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-04-21T00:32:24+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":107471,"lastUser":{"userID":107471,"name":"Restructor","url":"https:\/\/community.smartsheet.com\/profile\/Restructor","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AAuE7mC04YLN2mvy3JyIksAA0FRT84YxOAV_y7hYbNrmnw4","dateLastActive":"2020-01-13T12:04:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":14,"countViews":374,"score":null,"hot":14,"url":"https:\/\/community.smartsheet.com\/discussion\/128\/show-only-own-tasks-in-calendar","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/128\/show-only-own-tasks-in-calendar","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":241,"urlcode":"Calendar","name":"Calendar View"}],"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}]},{"discussionID":6249,"type":"discussion","name":"Formula to calculate the last update of a specific column","excerpt":"Hi. Is there a formula that will calculate the last time data in one specific column was updated? Thanks.","categoryID":318,"dateInserted":"2016-10-06T12:30:52+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-07T15:58:37+00:00","insertUserID":6167,"insertUser":{"userID":6167,"name":"Lisa Schick","url":"https:\/\/community.smartsheet.com\/profile\/Lisa%20Schick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-17T13:21:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":103251,"lastUser":{"userID":103251,"name":"brenttopa","url":"https:\/\/community.smartsheet.com\/profile\/brenttopa","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-23T09:18:55+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":8,"countViews":1930,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/6249\/formula-to-calculate-the-last-update-of-a-specific-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6249\/formula-to-calculate-the-last-update-of-a-specific-column","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":259,"urlcode":"IT & Operations","name":"IT & Operations"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">