公式

[Cust Requested…","categoryID":322,"dateInserted":"2018-04-04T14:59:56+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-04-09T17:09:30+00:00","insertUserID":27906,"insertUser":{"userID":27906,"name":"BlairMyles","url":"https:\/\/community.smartsheet.com\/profile\/BlairMyles","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-07-26T18:04:36+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":195,"lastUser":{"userID":195,"name":"Shaine Greenwood","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shaine%20Greenwood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/198\/nBSBY6VR571R7.jpg","dateLastActive":"2021-08-30T16:03:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":29,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/22771\/if-and-formula-help-required","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/22771\/if-and-formula-help-required","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":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"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":22696,"type":"discussion","name":"Count Ifs Formulas","excerpt":"I have created formulas to count the number of incoming quotes by month and according to if they have been Won\/Lost\/Pending. I use the exact same formula for March (month 3) and it works beautifully. For some reason the formula is not pulling in the info we have loaded up so far in April: =COUNTIFS([Conversion…","categoryID":322,"dateInserted":"2018-04-04T09:31:36+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-04-09T16:55:28+00:00","insertUserID":42051,"insertUser":{"userID":42051,"name":"Kate","url":"https:\/\/community.smartsheet.com\/profile\/Kate","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-04-04T09:27:26+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":195,"lastUser":{"userID":195,"name":"Shaine Greenwood","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shaine%20Greenwood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/198\/nBSBY6VR571R7.jpg","dateLastActive":"2021-08-30T16:03:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":27,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/22696\/count-ifs-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/22696\/count-ifs-formulas","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":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":23111,"type":"discussion","name":"Adding hours and minutes","excerpt":"Hello All, I am new to SS and am trying to figure out how to add these hours and minutes for the year (there will be more added each week). I have found some posts saying this is not possible but they are from last year. Has anyone mastered this issue? [**Malformed image removed by moderator**]","categoryID":322,"dateInserted":"2018-04-07T16:03:42+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-04-08T14:13:20+00:00","insertUserID":43911,"insertUser":{"userID":43911,"name":"Team Orbie 9","url":"https:\/\/community.smartsheet.com\/profile\/Team%20Orbie%209","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-13T19:51:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":43911,"lastUser":{"userID":43911,"name":"Team Orbie 9","url":"https:\/\/community.smartsheet.com\/profile\/Team%20Orbie%209","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-13T19:51:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":462,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/23111\/adding-hours-and-minutes","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/23111\/adding-hours-and-minutes","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-04\/32\/e2\/32e2d38d7dee8e099d00ddab1ab774f9.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Snap5.jpg"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"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":23106,"type":"discussion","name":"Yet another RYG Balls Question","excerpt":"Hi all, Can someone either let me know or point in the direction of a post that would assist me in solving for the following. I am trying to create a formula that would: * Return red ball if date in a column titled \"Last contacted\" contains a date that is 30 days or over. * Return a yellow ball if the same column has a…","categoryID":322,"dateInserted":"2018-04-07T12:29:29+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-04-08T06:47:58+00:00","insertUserID":43901,"insertUser":{"userID":43901,"name":"66Lambretta","url":"https:\/\/community.smartsheet.com\/profile\/66Lambretta","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-04-07T12:19:01+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":23666,"lastUser":{"userID":23666,"name":"Chris McKay","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20McKay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-09\/d5\/d2\/nd5d2693be28ccbd24f978b00c5d1db1d.JPG","dateLastActive":"2018-08-14T22:59:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":27,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/23106\/yet-another-ryg-balls-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/23106\/yet-another-ryg-balls-question","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":254,"urlcode":"Formulas","name":"Formulas"},{"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}]},{"discussionID":23091,"type":"discussion","name":"Formula Help","excerpt":"I have one column with a person's first name, then I have another column that I want to be just the first initial of the previous column's first person's name. Instead of typing in the first initial every time, I want to know if there is a formula I can put in the initial column??","categoryID":322,"dateInserted":"2018-04-06T21:16:00+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-04-07T10:11:30+00:00","insertUserID":43876,"insertUser":{"userID":43876,"name":"Manda_Panda","url":"https:\/\/community.smartsheet.com\/profile\/Manda_Panda","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-04-06T21:11:55+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":23666,"lastUser":{"userID":23666,"name":"Chris McKay","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20McKay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-09\/d5\/d2\/nd5d2693be28ccbd24f978b00c5d1db1d.JPG","dateLastActive":"2018-08-14T22:59:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":28,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/23091\/formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/23091\/formula-help","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":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":22971,"type":"discussion","name":"How to make formulas work on top of a sheet if new entries are coming on the bottom of the sheet via","excerpt":"Hi All I am really stuck with this as I need to amend my fomulas manually every time I have a new entry. Whenever there is a new entry ( via Web-form) I need to change the formula to include the new row instead of helping me with automation it has created extra work for me. Did any of you faced a similar problem? What…","categoryID":322,"dateInserted":"2018-04-06T06:48:28+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-04-07T07:44:48+00:00","insertUserID":10378,"insertUser":{"userID":10378,"name":"Noemi Kecskes","url":"https:\/\/community.smartsheet.com\/profile\/Noemi%20Kecskes","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-03-14T08:37:21+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-20T12:27:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":314,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/22971\/how-to-make-formulas-work-on-top-of-a-sheet-if-new-entries-are-coming-on-the-bottom-of-the-sheet-via","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/22971\/how-to-make-formulas-work-on-top-of-a-sheet-if-new-entries-are-coming-on-the-bottom-of-the-sheet-via","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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":244,"urlcode":"Product Development","name":"Product Development"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":271,"urlcode":"Services","name":"Services"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">