@1970Sarah<\/a> <\/p>When you added the additional Index\/Collect, you needed to add an additional row index parameter (the 1 at the end of the INDEX clause) to complete the new Index\/Collect<\/p>
Try this<\/p>
=IFERROR(IF(Location@row = \"US\", INDEX(COLLECT({Internal Resource Rates | US $}, {Internal Resource Rates | Service Line}, CONTAINS([Service Line]@row, @cell), {Internal Resource Rates | Internal Role}, [Internal Role]@row),1), INDEX(COLLECT({Internal Resource Rates | UK £}, {Internal Resource Rates | Service Line}, CONTAINS([Service Line]@row, @cell), {Internal Resource Rates | Internal Role}, [Internal Role]@row), 1)), \"//www.santa-greenland.com/\")<\/p>
Does this work for you?<\/p>
Kelly<\/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":96999,"type":"question","name":"Move rows (workflow) change sheet destination when saving as new","excerpt":"Well, this is the context: I have a project template folder in a Smartsheet's Workspace that includes some sheets and reports that I use in my projects. The problem that I have right now is that I created a workflow for the project plan sheet that when it's triggered, it moves a specific row to a sheet called \"On Hold…","categoryID":322,"dateInserted":"2022-10-26T01:10:31+00:00","dateUpdated":null,"dateLastComment":"2022-10-26T01:10:31+00:00","insertUserID":154097,"insertUser":{"userID":154097,"name":"EdsonCrz94","url":"https:\/\/community.smartsheet.com\/profile\/EdsonCrz94","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T01:10:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":154097,"lastUser":{"userID":154097,"name":"EdsonCrz94","url":"https:\/\/community.smartsheet.com\/profile\/EdsonCrz94","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T01:10:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":3,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/96999\/move-rows-workflow-change-sheet-destination-when-saving-as-new","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96999\/move-rows-workflow-change-sheet-destination-when-saving-as-new","format":"Rich","lastPost":{"discussionID":96999,"name":"Move rows (workflow) change sheet destination when saving as new","url":"https:\/\/community.smartsheet.com\/discussion\/96999\/move-rows-workflow-change-sheet-destination-when-saving-as-new","dateInserted":"2022-10-26T01:10:31+00:00","insertUserID":154097,"insertUser":{"userID":154097,"name":"EdsonCrz94","url":"https:\/\/community.smartsheet.com\/profile\/EdsonCrz94","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T01:10:38+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":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","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":96998,"type":"question","name":"Move rows (workflow) change sheet destination when saving as new","excerpt":"Well, this is the context: I have a project template folder in a Smartsheet's Workspace that includes some sheets and reports that I use in my projects. The problem that I have right now is that I created a workflow for the project plan sheet that when it's triggered, it moves a specific row to a sheet called \"On Hold…","categoryID":322,"dateInserted":"2022-10-26T01:10:15+00:00","dateUpdated":null,"dateLastComment":"2022-10-26T01:10:15+00:00","insertUserID":154097,"insertUser":{"userID":154097,"name":"EdsonCrz94","url":"https:\/\/community.smartsheet.com\/profile\/EdsonCrz94","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T01:10:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":154097,"lastUser":{"userID":154097,"name":"EdsonCrz94","url":"https:\/\/community.smartsheet.com\/profile\/EdsonCrz94","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T01:10:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":1,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/96998\/move-rows-workflow-change-sheet-destination-when-saving-as-new","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96998\/move-rows-workflow-change-sheet-destination-when-saving-as-new","format":"Rich","lastPost":{"discussionID":96998,"name":"Move rows (workflow) change sheet destination when saving as new","url":"https:\/\/community.smartsheet.com\/discussion\/96998\/move-rows-workflow-change-sheet-destination-when-saving-as-new","dateInserted":"2022-10-26T01:10:15+00:00","insertUserID":154097,"insertUser":{"userID":154097,"name":"EdsonCrz94","url":"https:\/\/community.smartsheet.com\/profile\/EdsonCrz94","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T01:10:38+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":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","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":96994,"type":"question","name":"Need to verify SUMIFS formula - Incorrect arrgument set","excerpt":"=SUMIFS([Diagnostic]:[In Progress], 1, [Start Date]:[Start Date], IFERROR(YEAR(@cell), 0) = 2022) Want to sum values in columns Diagnostic, Disc and In Progress where the date\/year is 2022. The columns are in this order - Diagnostic, Discovery and In Progress. With 1 or 0 values in them. I need a sum of all these 3 columns…","categoryID":322,"dateInserted":"2022-10-25T23:06:37+00:00","dateUpdated":null,"dateLastComment":"2022-10-26T00:25:13+00:00","insertUserID":153291,"insertUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T00:50:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":153291,"lastUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T00:50:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":15,"score":null,"hot":3333483710,"url":"https:\/\/community.smartsheet.com\/discussion\/96994\/need-to-verify-sumifs-formula-incorrect-arrgument-set","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96994\/need-to-verify-sumifs-formula-incorrect-arrgument-set","format":"Rich","lastPost":{"discussionID":96994,"commentID":348642,"name":"Re: Need to verify SUMIFS formula - Incorrect arrgument set","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348642#Comment_348642","dateInserted":"2022-10-26T00:25:13+00:00","insertUserID":153291,"insertUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T00:50:29+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":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-10-26T00:25:13+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-26 00:25:15","updateUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T00:50:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":96959,"type":"question","name":"Dashboard auto color metrics.","excerpt":"Is there a way to auto color metrics (derived from Smartsheet Summary section) percentages on Dashboard ? EX: If the production rate is over the set goal - auto color the percentage number on dashboard to green if not auto color the percentage to red to indicate below goal ?","categoryID":322,"dateInserted":"2022-10-25T14:43:48+00:00","dateUpdated":null,"dateLastComment":"2022-10-26T00:07:31+00:00","insertUserID":153291,"insertUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T00:50:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":153291,"lastUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T00:50:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":18,"score":null,"hot":3333453079,"url":"https:\/\/community.smartsheet.com\/discussion\/96959\/dashboard-auto-color-metrics","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96959\/dashboard-auto-color-metrics","format":"Rich","lastPost":{"discussionID":96959,"commentID":348641,"name":"Re: Dashboard auto color metrics.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348641#Comment_348641","dateInserted":"2022-10-26T00:07:31+00:00","insertUserID":153291,"insertUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T00:50:29+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":"2022-10-26T00:07:35+00:00","dateAnswered":"2022-10-25T14:59:36+00:00","acceptedAnswers":[{"commentID":348581,"body":"
Can only be done if the metric is coming from a cell (using conditional formatting on the sheet level).<\/p>
This is not available form the sheet Summary<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-26 00:07:35","updateUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T00:50:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]}],"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}},{"label":"Newest Questions","componentName":"DiscussionListModule","componentProps":{"apiParams":{"type":"question","sort":"-dateInserted","limit":5,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","expand":["all","-body"]},"discussions":[{"discussionID":96999,"type":"question","name":"Move rows (workflow) change sheet destination when saving as new","excerpt":"Well, this is the context: I have a project template folder in a Smartsheet's Workspace that includes some sheets and reports that I use in my projects. The problem that I have right now is that I created a workflow for the project plan sheet that when it's triggered, it moves a specific row to a sheet called \"On Hold…","categoryID":322,"dateInserted":"2022-10-26T01:10:31+00:00","dateUpdated":null,"dateLastComment":"2022-10-26T01:10:31+00:00","insertUserID":154097,"insertUser":{"userID":154097,"name":"EdsonCrz94","url":"https:\/\/community.smartsheet.com\/profile\/EdsonCrz94","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T01:10:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":154097,"lastUser":{"userID":154097,"name":"EdsonCrz94","url":"https:\/\/community.smartsheet.com\/profile\/EdsonCrz94","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T01:10:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":3,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/96999\/move-rows-workflow-change-sheet-destination-when-saving-as-new","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96999\/move-rows-workflow-change-sheet-destination-when-saving-as-new","format":"Rich","lastPost":{"discussionID":96999,"name":"Move rows (workflow) change sheet destination when saving as new","url":"https:\/\/community.smartsheet.com\/discussion\/96999\/move-rows-workflow-change-sheet-destination-when-saving-as-new","dateInserted":"2022-10-26T01:10:31+00:00","insertUserID":154097,"insertUser":{"userID":154097,"name":"EdsonCrz94","url":"https:\/\/community.smartsheet.com\/profile\/EdsonCrz94","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T01:10:38+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":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","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":96998,"type":"question","name":"Move rows (workflow) change sheet destination when saving as new","excerpt":"Well, this is the context: I have a project template folder in a Smartsheet's Workspace that includes some sheets and reports that I use in my projects. The problem that I have right now is that I created a workflow for the project plan sheet that when it's triggered, it moves a specific row to a sheet called \"On Hold…","categoryID":322,"dateInserted":"2022-10-26T01:10:15+00:00","dateUpdated":null,"dateLastComment":"2022-10-26T01:10:15+00:00","insertUserID":154097,"insertUser":{"userID":154097,"name":"EdsonCrz94","url":"https:\/\/community.smartsheet.com\/profile\/EdsonCrz94","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T01:10:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":154097,"lastUser":{"userID":154097,"name":"EdsonCrz94","url":"https:\/\/community.smartsheet.com\/profile\/EdsonCrz94","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T01:10:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":1,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/96998\/move-rows-workflow-change-sheet-destination-when-saving-as-new","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96998\/move-rows-workflow-change-sheet-destination-when-saving-as-new","format":"Rich","lastPost":{"discussionID":96998,"name":"Move rows (workflow) change sheet destination when saving as new","url":"https:\/\/community.smartsheet.com\/discussion\/96998\/move-rows-workflow-change-sheet-destination-when-saving-as-new","dateInserted":"2022-10-26T01:10:15+00:00","insertUserID":154097,"insertUser":{"userID":154097,"name":"EdsonCrz94","url":"https:\/\/community.smartsheet.com\/profile\/EdsonCrz94","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T01:10:38+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":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","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":96996,"type":"question","name":"IF formula stops referencing columns after a certain point unless I manually type","excerpt":"I have a survey going to to people with 56 compliance rules. When the survey answers as \"out of compliance\" I have a rules column for each rule change that to a \"1\". Another column I've made have multiple selection options with the rule number and compliance issue. So Ideally when someone answers \"out of compliance for…","categoryID":322,"dateInserted":"2022-10-25T23:40:10+00:00","dateUpdated":null,"dateLastComment":"2022-10-25T23:40:10+00:00","insertUserID":154120,"insertUser":{"userID":154120,"name":"pzupan","url":"https:\/\/community.smartsheet.com\/profile\/pzupan","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-o8tt8oEGno!HeEu3-pvkfo!FyR8VY7Y94B","dateLastActive":"2022-10-25T23:40:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":154120,"lastUser":{"userID":154120,"name":"pzupan","url":"https:\/\/community.smartsheet.com\/profile\/pzupan","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-o8tt8oEGno!HeEu3-pvkfo!FyR8VY7Y94B","dateLastActive":"2022-10-25T23:40:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":5,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/96996\/if-formula-stops-referencing-columns-after-a-certain-point-unless-i-manually-type","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96996\/if-formula-stops-referencing-columns-after-a-certain-point-unless-i-manually-type","format":"Rich","tagIDs":[333],"lastPost":{"discussionID":96996,"name":"IF formula stops referencing columns after a certain point unless I manually type","url":"https:\/\/community.smartsheet.com\/discussion\/96996\/if-formula-stops-referencing-columns-after-a-certain-point-unless-i-manually-type","dateInserted":"2022-10-25T23:40:10+00:00","insertUserID":154120,"insertUser":{"userID":154120,"name":"pzupan","url":"https:\/\/community.smartsheet.com\/profile\/pzupan","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-o8tt8oEGno!HeEu3-pvkfo!FyR8VY7Y94B","dateLastActive":"2022-10-25T23:40:14+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":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","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":[{"tagID":333,"urlcode":"Workflows in Smartsheet","name":"Workflows in Smartsheet"}]},{"discussionID":96995,"type":"question","name":"Creating Formula from a linked sheet","excerpt":"Need Help. I have two sheets- Sheet1, has all the Survey Values (i.e, Yes, No, NA), and Sheet2 will have all the Formula. I want to assign a numerical value on the answers of Sheet1. For instance, Yes= 15, No= 0, N\/A =0, and have them all populate in Sheet 2. So here is my formula in Sheet2 =IF({Sheet1} = \"Yes\", 15,…","categoryID":322,"dateInserted":"2022-10-25T23:07:19+00:00","dateUpdated":null,"dateLastComment":"2022-10-25T23:07:19+00:00","insertUserID":154122,"insertUser":{"userID":154122,"name":"Joyce Y.","url":"https:\/\/community.smartsheet.com\/profile\/Joyce%20Y.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-25T23:59:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":154122,"lastUser":{"userID":154122,"name":"Joyce Y.","url":"https:\/\/community.smartsheet.com\/profile\/Joyce%20Y.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-25T23:59:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":6,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/96995\/creating-formula-from-a-linked-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96995\/creating-formula-from-a-linked-sheet","format":"Rich","lastPost":{"discussionID":96995,"name":"Creating Formula from a linked sheet","url":"https:\/\/community.smartsheet.com\/discussion\/96995\/creating-formula-from-a-linked-sheet","dateInserted":"2022-10-25T23:07:19+00:00","insertUserID":154122,"insertUser":{"userID":154122,"name":"Joyce Y.","url":"https:\/\/community.smartsheet.com\/profile\/Joyce%20Y.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-25T23:59:55+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":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","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":96994,"type":"question","name":"Need to verify SUMIFS formula - Incorrect arrgument set","excerpt":"=SUMIFS([Diagnostic]:[In Progress], 1, [Start Date]:[Start Date], IFERROR(YEAR(@cell), 0) = 2022) Want to sum values in columns Diagnostic, Disc and In Progress where the date\/year is 2022. The columns are in this order - Diagnostic, Discovery and In Progress. With 1 or 0 values in them. I need a sum of all these 3 columns…","categoryID":322,"dateInserted":"2022-10-25T23:06:37+00:00","dateUpdated":null,"dateLastComment":"2022-10-26T00:25:13+00:00","insertUserID":153291,"insertUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T00:50:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":153291,"lastUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T00:50:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":15,"score":null,"hot":3333483710,"url":"https:\/\/community.smartsheet.com\/discussion\/96994\/need-to-verify-sumifs-formula-incorrect-arrgument-set","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96994\/need-to-verify-sumifs-formula-incorrect-arrgument-set","format":"Rich","lastPost":{"discussionID":96994,"commentID":348642,"name":"Re: Need to verify SUMIFS formula - Incorrect arrgument set","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348642#Comment_348642","dateInserted":"2022-10-26T00:25:13+00:00","insertUserID":153291,"insertUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T00:50:29+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":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-10-26T00:25:13+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-26 00:25:15","updateUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T00:50:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]}],"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}}],"defaultTabIndex":0}">
