非营利性的
讨论表
map-friendly), is there any way to add location from the mobile device being used to submit the Web Form? Apologies in advance if this…","categoryID":318,"dateInserted":"2016-07-28T15:03:39+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-07-28T17:32:11+00:00","insertUserID":7683,"insertUser":{"userID":7683,"name":"Sarah Gray","url":"https:\/\/community.smartsheet.com\/profile\/Sarah%20Gray","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-07-06T10:35:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":2858,"lastUser":{"userID":2858,"name":"Brett Evans","url":"https:\/\/community.smartsheet.com\/profile\/Brett%20Evans","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-01T19:43:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":14,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/5644\/adding-current-location-to-web-form-from-mobile-device","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5644\/adding-current-location-to-web-form-from-mobile-device","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":204,"urlcode":"Forms","name":"Forms"},{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":234,"urlcode":"Health-care","name":"Healthcare"},{"tagID":246,"urlcode":"Mobile","name":"Mobile"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":344,"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}]},{"discussionID":5626,"type":"discussion","name":"Formula help...can this be done?","excerpt":"Column A is a date column. Column B tells us if we have scheduled Column A so it will sort into the right report. The formula in Column B needs to state that if Column A is a date, then the value is YES; If Column A says \"Not Scheduled\" it is No. Otherwise, Column B will remain blank. Can that be done? Blessings, Loann","categoryID":318,"dateInserted":"2016-07-27T10:18:22+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-07-27T11:30:22+00:00","insertUserID":254,"insertUser":{"userID":254,"name":"Loann McGee","url":"https:\/\/community.smartsheet.com\/profile\/Loann%20McGee","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/G3A1KBYOQBWU\/nBYWBBSSF9DWC.jpg","dateLastActive":"2023-06-13T21:03:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":254,"lastUser":{"userID":254,"name":"Loann McGee","url":"https:\/\/community.smartsheet.com\/profile\/Loann%20McGee","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/G3A1KBYOQBWU\/nBYWBBSSF9DWC.jpg","dateLastActive":"2023-06-13T21:03:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":13,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/5626\/formula-help-can-this-be-done","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5626\/formula-help-can-this-be-done","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":209,"urlcode":"Media & Entertainment","name":"Media & Entertainment"},{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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":5621,"type":"discussion","name":"RYG balls based on dates of activities completed","excerpt":"I have been following some threads discussing how to use RYG balls in conditional formulae based on a date column (i.e. green if the date is in the future, yellow if it is today, red if in the past, etc.), and those are very helpful! I would like to do the following, however, and I cannot find a thread that addresses this…","categoryID":318,"dateInserted":"2016-07-26T08:53:52+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-07-26T16:57:39+00:00","insertUserID":7640,"insertUser":{"userID":7640,"name":"Debra Olson","url":"https:\/\/community.smartsheet.com\/profile\/Debra%20Olson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-07-26T08:44:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":7640,"lastUser":{"userID":7640,"name":"Debra Olson","url":"https:\/\/community.smartsheet.com\/profile\/Debra%20Olson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-07-26T08:44:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":34,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/5621\/ryg-balls-based-on-dates-of-activities-completed","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5621\/ryg-balls-based-on-dates-of-activities-completed","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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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":5475,"type":"discussion","name":"Text\/Number column is editing my number","excerpt":"I input the number 2800.06610 and Smartsheet edits my number to 2800.0661 which means it is eliminating the zero. This column does not have any conditional formating. What am I doing wrong?","categoryID":318,"dateInserted":"2016-07-12T12:54:42+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-07-13T11:28:45+00:00","insertUserID":6716,"insertUser":{"userID":6716,"name":"Christian Jensen","url":"https:\/\/community.smartsheet.com\/profile\/Christian%20Jensen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-05-30T12:40:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":453,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/5475\/text-number-column-is-editing-my-number","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5475\/text-number-column-is-editing-my-number","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":219,"urlcode":"Sheets","name":"Sheets"}],"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}">