讨论
=MONTH(TODAY()), Client66:Client77, Stage:Stage, \"Stage 1 Prospecting\") The month # is 1-12 on each row for each monthly calculation of TCV , and then the Client is the actual monthly calculation. I am getting an invalid operation error. What I…","categoryID":322,"dateInserted":"2021-09-03T16:36:24+00:00","dateUpdated":null,"dateLastComment":"2021-09-06T12:24:04+00:00","insertUserID":139588,"insertUser":{"userID":139588,"name":"Chandlerw","url":"https:\/\/community.smartsheet.com\/profile\/Chandlerw","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-10-22T14:27:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-12-05T20:32:02+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":46,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/82800\/sum-ifs-formula-to-calculate-everything-in-a-certain-stage-each-month-if-that-month-is-in-the-future","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/82800\/sum-ifs-formula-to-calculate-everything-in-a-certain-stage-each-month-if-that-month-is-in-the-future","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-09-06T12:24:04+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":false,"noCheckboxes":true}">
