Want to practice working with formulas directly in Smartsheet?

Check out theFormula Handbook templateto view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.

Formulas and Functions

Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.

Discussion List

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Popular Tags

Want to practice working with formulas directly in Smartsheet?

Check out the公式手册模板!
Hi @Cheryl Collins<\/a> <\/p>

I hope you're well and safe!<\/p>

You have to sum them up one by one and add them together.<\/p>

Try something like this.<\/p>

=SUMIFS([No. of Minutes Taken to Complete Job]:[No. of Minutes Taken to Complete Job], [Job Type]:[Job Type], \"CD Creation\") + SUMIFS([No. of Minutes Taken to Complete Job]:[No. of Minutes Taken to Complete Job], [Job Type]:[Job Type], \"CD Extraction\") + SUMIFS([No. of Minutes Taken to Complete Job]:[No. of Minutes Taken to Complete Job], [Job Type]:[Job Type], \"Print & Post\") + SUMIFS([No. of Minutes Taken to Complete Job]:[No. of Minutes Taken to Complete Job], [Job Type]:[Job Type], \"USB Creation\") + SUMIFS([No. of Minutes Taken to Complete Job]:[No. of Minutes Taken to Complete Job], [Job Type]:[Job Type], \"USB Extraction\")<\/p>

Did that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"},{"commentID":351643,"body":"

@Cheryl Collins<\/a> <\/p>

Try this.<\/p>

=SUMIFS([No. of Minutes Taken to Complete Job]:[No. of Minutes Taken to Complete Job], [Job Type]:[Job Type], \"CD Creation\", [Date Received]:[Date Received], IFERROR(MONTH(@cell), 0) = MONTH(TODAY())) + SUMIFS([No. of Minutes Taken to Complete Job]:[No. of Minutes Taken to Complete Job], [Job Type]:[Job Type], \"CD Extraction\", [Date Received]:[Date Received], IFERROR(MONTH(@cell), 0) = MONTH(TODAY())) + SUMIFS([No. of Minutes Taken to Complete Job]:[No. of Minutes Taken to Complete Job], [Job Type]:[Job Type], \"Print & Post\", [Date Received]:[Date Received], IFERROR(MONTH(@cell), 0) = MONTH(TODAY())) + SUMIFS([No. of Minutes Taken to Complete Job]:[No. of Minutes Taken to Complete Job], [Job Type]:[Job Type], \"USB Creation\", [Date Received]:[Date Received], IFERROR(MONTH(@cell), 0) = MONTH(TODAY())) + SUMIFS([No. of Minutes Taken to Complete Job]:[No. of Minutes Taken to Complete Job], [Job Type]:[Job Type], \"USB Extraction\", [Date Received]:[Date Received], IFERROR(MONTH(@cell), 0) = MONTH(TODAY()))<\/p>

Did that work?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-17 14:37:03","updateUser":{"userID":125322,"name":"Cheryl Collins","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Cheryl%20Collins","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ujDUd8trmpQ!HMFV36dbhPo!OB9bg9sjUrN","dateLastActive":"2022-11-18T08:14:14+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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":97908,"type":"question","name":"My COUNTIF formula is returning 0 instead of the correct decimal value. What am I doing wrong?","excerpt":"Hi, I am using this formula in a supporting sheet to calculate readiness for a task, but I keep getting zeros no matter what... =COUNTIF({Cross-site IHA Yes}, 1 \/ COUNTIF({Cross-Site IHA Ask 1}, 1)) Essentially this is saying, count all the \"checked\" boxes in column 1 and divide them by the number of boxes \"checked\" in…","categoryID":322,"dateInserted":"2022-11-17T19:16:02+00:00","dateUpdated":null,"dateLastComment":"2022-11-17T19:20:55+00:00","insertUserID":148706,"insertUser":{"userID":148706,"name":"Bradhickswa","url":"https:\/\/community.smartsheet.com\/profile\/Bradhickswa","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!AuHRX9yKuf0!3hlSP6CUF7s!8dWYTxFWd_v","dateLastActive":"2022-11-17T19:23:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":148706,"lastUser":{"userID":148706,"name":"Bradhickswa","url":"https:\/\/community.smartsheet.com\/profile\/Bradhickswa","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!AuHRX9yKuf0!3hlSP6CUF7s!8dWYTxFWd_v","dateLastActive":"2022-11-17T19:23:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":15,"score":null,"hot":3337426617,"url":"https:\/\/community.smartsheet.com\/discussion\/97908\/my-countif-formula-is-returning-0-instead-of-the-correct-decimal-value-what-am-i-doing-wrong","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97908\/my-countif-formula-is-returning-0-instead-of-the-correct-decimal-value-what-am-i-doing-wrong","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":97908,"commentID":351599,"name":"Re: My COUNTIF formula is returning 0 instead of the correct decimal value. What am I doing wrong?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/351599#Comment_351599","dateInserted":"2022-11-17T19:20:55+00:00","insertUserID":148706,"insertUser":{"userID":148706,"name":"Bradhickswa","url":"https:\/\/community.smartsheet.com\/profile\/Bradhickswa","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!AuHRX9yKuf0!3hlSP6CUF7s!8dWYTxFWd_v","dateLastActive":"2022-11-17T19:23: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":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-17T19:20:47+00:00","dateAnswered":"2022-11-17T19:17:59+00:00","acceptedAnswers":[{"commentID":351598,"body":"

@Bradhickswa<\/a> <\/p>

=COUNTIF({Cross-site IHA Yes}, 1) \/ COUNTIF({Cross-Site IHA Ask 1}, 1)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-17 19:20:47","updateUser":{"userID":148706,"name":"Bradhickswa","url":"https:\/\/community.smartsheet.com\/profile\/Bradhickswa","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!AuHRX9yKuf0!3hlSP6CUF7s!8dWYTxFWd_v","dateLastActive":"2022-11-17T19:23:55+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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":97907,"type":"question","name":"If\/And\/ISDate\/OR","excerpt":"Hi All I am trying to set up a status message based on a few variables. I can get them to work indidually, but when I bring them all together I get an InvalidData error. The parameters are If FWA Required= YES and FWA attestation is Date and Date Attestation Form Signed is Date and Education Completion Date is Date. If all…","categoryID":322,"dateInserted":"2022-11-17T18:53:24+00:00","dateUpdated":null,"dateLastComment":"2022-11-17T19:30:03+00:00","insertUserID":127418,"insertUser":{"userID":127418,"name":"Laura Bartlett","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Laura%20Bartlett","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-17T19:33:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":127418,"lastUser":{"userID":127418,"name":"Laura Bartlett","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Laura%20Bartlett","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-17T19:33:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3337425807,"url":"https:\/\/community.smartsheet.com\/discussion\/97907\/if-and-isdate-or","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97907\/if-and-isdate-or","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":97907,"commentID":351604,"name":"Re: If\/And\/ISDate\/OR","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/351604#Comment_351604","dateInserted":"2022-11-17T19:30:03+00:00","insertUserID":127418,"insertUser":{"userID":127418,"name":"Laura Bartlett","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Laura%20Bartlett","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-17T19:33:24+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/IPSS0VO53TSQ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-17T19:33:22+00:00","dateAnswered":"2022-11-17T19:24:28+00:00","acceptedAnswers":[{"commentID":351600,"body":"

@Laura Bartlett<\/a> <\/p>

2 Things:<\/p>

  1. whenever you are using the ISDATE function you don't need to add =\"true\"<\/strong><\/li>
  2. You can combine the 2 options for 'complete' into 1 using the OR function.<\/li><\/ol>

    See below formula:<\/p>

    =IF(OR(AND([FWA Required?]@row = \"Yes\", ISDATE([FWA Attestation Form Signed?]@row), ISDATE([Education Completion Date]@row), ISDATE([Date Attestation Form Signed?]@row)),AND([FWA Required?]@row = \"No\", ISDATE([Date Attestation Form Signed?]@row),ISDATE([Education Completion Date]@row))), \"Complete\", \"Not Complete\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-17 19:33:22","updateUser":{"userID":127418,"name":"Laura Bartlett","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Laura%20Bartlett","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-17T19:33:24+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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">