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.

Product questions?
Sign in andask it here!The community's got your back.

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Popular Tags

Want to practice working with formulas directly in Smartsheet?

Check out the公式手册模板!

Give this a try:<\/p>

=IF(ISBLANK([Other Concerns]@row), [Name of Company]@row + \" presently had no other comments or concerns.\", [Name of Company]@row + \" also responded that \" + [Other Concerns]@row)<\/p>"},{"commentID":402554,"body":"

@Carson Penticuff<\/a> This worked!<\/p>

Hi @Joseph Aloysias<\/a> <\/p>

Thank you for clarifying!<\/p>

It sounds like you may be moving the original Row 1 <\/strong>from your current sheet into the archive sheet. When this happens, the reference is deleted since you're referencing that specific row:<\/p>

=[Initial Stock]@row - SUMIFS([Total Quantity Requested]$1<\/strong>:[Total Quantity Requested]@row, Collected$1<\/strong>:Collected@row, 1, [Item_ID]$1<\/strong>:[Item_ID]@row, [Item_ID]@row)<\/p>

This is why you see the error #REF<\/p>

You'll want to make sure Row 1 in your current sheet is a row that will never be moved, so you can keep the reference. Does that make sense?<\/p>

Cheers,<\/p>

Can this be modified at all?<\/p><\/div><\/div>

Try this:<\/p>

=SUMIFS([Predicted Cost of Incident]:[Predicted Cost of Incident], [Date of Incident]:[Date of Incident], AND(@cell >= DATE(2023, 4, 1), @cell <= DATE(2023, 4, 30)), [Department Involved]:[Department Involved], \"Fabrication\")<\/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":["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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&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 in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">