\n Cheers,<\/p>
Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"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":107360,"type":"question","name":"INCORRECT ARGUMENT error when using IFERROR, NETWORKDAY AND @ROW on a date column","excerpt":"Hello, I am trying to return a networkday value in a date column only when there are dates in the columns but am getting an \"incorrect argument\" error. I also need it to be a column formula so am using @row. Can someone provide insight on how to adjust the formula? =IFERROR(NETWORKDAY([Date of Triage Request]@row, [Date…","snippet":"Hello, I am trying to return a networkday value in a date column only when there are dates in the columns but am getting an \"incorrect argument\" error. I also need it to be a…","categoryID":322,"dateInserted":"2023-07-08T13:16:49+00:00","dateUpdated":null,"dateLastComment":"2023-07-08T21:24:27+00:00","insertUserID":163251,"insertUser":{"userID":163251,"name":"m_schmidt","title":"project manager","url":"https:\/\/community.smartsheet.com\/profile\/m_schmidt","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-08T21:48:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":163251,"lastUser":{"userID":163251,"name":"m_schmidt","title":"project manager","url":"https:\/\/community.smartsheet.com\/profile\/m_schmidt","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-08T21:48:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":29,"score":null,"hot":3377674876,"url":"https:\/\/community.smartsheet.com\/discussion\/107360\/incorrect-argument-error-when-using-iferror-networkday-and-row-on-a-date-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107360\/incorrect-argument-error-when-using-iferror-networkday-and-row-on-a-date-column","format":"Rich","lastPost":{"discussionID":107360,"commentID":384273,"name":"Re: INCORRECT ARGUMENT error when using IFERROR, NETWORKDAY AND @ROW on a date column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384273#Comment_384273","dateInserted":"2023-07-08T21:24:27+00:00","insertUserID":163251,"insertUser":{"userID":163251,"name":"m_schmidt","title":"project manager","url":"https:\/\/community.smartsheet.com\/profile\/m_schmidt","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-08T21:48:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-10T09:21:36+00:00","dateAnswered":"2023-07-08T18:25:31+00:00","acceptedAnswers":[{"commentID":384271,"body":"
It looks like you may have misplaced a parenthesis, try this:<\/p>
=IFERROR(NETWORKDAY([Date of Triage Request]@row, [Date submitted to FDA]@row), \"//www.santa-greenland.com/community/categories/c2017/\")<\/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":107335,"type":"question","name":"SUMIFS - Stumped on calculation to figure out if within a month","excerpt":"Hi All, I am using SUMIFS to calculate if a part is in the Spend Formulas Range sheet and then if that same part has a Date that is within the month of January. The formula seems to break when the dates come in. =SUMIFS({2023 Spend Formulas Range 1}, {2023 Spend Formulas Range 2}, [Original Material #]@row,…","snippet":"Hi All, I am using SUMIFS to calculate if a part is in the Spend Formulas Range sheet and then if that same part has a Date that is within the month of January. The formula seems…","categoryID":322,"dateInserted":"2023-07-07T12:42:16+00:00","dateUpdated":null,"dateLastComment":"2023-07-07T18:51:25+00:00","insertUserID":151347,"insertUser":{"userID":151347,"name":"MegBurns23","url":"https:\/\/community.smartsheet.com\/profile\/MegBurns23","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3JFev2akC_o!bRNeG5LETzw!9HYHhXoqNPO","dateLastActive":"2023-07-07T19:28:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":151347,"lastUser":{"userID":151347,"name":"MegBurns23","url":"https:\/\/community.smartsheet.com\/profile\/MegBurns23","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3JFev2akC_o!bRNeG5LETzw!9HYHhXoqNPO","dateLastActive":"2023-07-07T19:28:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":72,"score":null,"hot":3377493221,"url":"https:\/\/community.smartsheet.com\/discussion\/107335\/sumifs-stumped-on-calculation-to-figure-out-if-within-a-month","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107335\/sumifs-stumped-on-calculation-to-figure-out-if-within-a-month","format":"Rich","lastPost":{"discussionID":107335,"commentID":384224,"name":"Re: SUMIFS - Stumped on calculation to figure out if within a month","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384224#Comment_384224","dateInserted":"2023-07-07T18:51:25+00:00","insertUserID":151347,"insertUser":{"userID":151347,"name":"MegBurns23","url":"https:\/\/community.smartsheet.com\/profile\/MegBurns23","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3JFev2akC_o!bRNeG5LETzw!9HYHhXoqNPO","dateLastActive":"2023-07-07T19:28:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-07T18:12:06+00:00","dateAnswered":"2023-07-07T13:19:00+00:00","acceptedAnswers":[{"commentID":384153,"body":"
You need something more like this:<\/p>
=SUMIFS({2023 Spend Formulas Range 1}, {2023 Spend Formulas Range 2}, [Original Material #]@row, {Date Range}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2023)<\/strong>)<\/p>
Then yes. You can drop them all inside of a SUM function or you can add them all together.<\/p>
=SUM(SUMIFS(.....), SUMIFS(.....), SUMIFS(.....))<\/p>
or<\/p>
=SUMIFS(.....) + SUMIFS(.....) + SUMIFS(.....)<\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
Trending Posts
Bridge to update column ID in column description Hi @Genevieve P. I am looking to develop a "utility" workflow that I can use when developing solutions. My idea is to use the "List Columns" element to gather the column ID's, and then a child workflow and "Update Columns" to update cycle through {{states.listcolumns.smartsheet.list_columns.data.x.column_id}} where x is…
INCORRECT ARGUMENT error when using IFERROR, NETWORKDAY AND @ROW on a date column Hello, I am trying to return a networkday value in a date column only when there are dates in the columns but am getting an "incorrect argument" error. I also need it to be a column formula so am using @row. Can someone provide insight on how to adjust the formula? =IFERROR(NETWORKDAY([Date of Triage Request]@row, [Date…
SUMIFS - Stumped on calculation to figure out if within a month Hi All, I am using SUMIFS to calculate if a part is in the Spend Formulas Range sheet and then if that same part has a Date that is within the month of January. The formula seems to break when the dates come in. =SUMIFS({2023 Spend Formulas Range 1}, {2023 Spend Formulas Range 2}, [Original Material #]@row,…
![\"Screenshot](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/LHHMII8CJOAT\/screenshot-2023-07-07-at-13-14-59.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"Screenshot](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/1G9O2BCR3VI3\/screenshot-2023-07-07-at-13-15-51.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"Screenshot](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/0P150PV6SZQC\/screenshot-2023-07-07-at-13-18-07.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
