Check out theFormula Handbook templateto view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.
Sign in andask it here!The community's got your back.
Wondering if there’s a problem?
Check out theStatus Pageand subscribe for notifications.
Share your knowledge!
Help others byanswering questions.
Formulas and Functions
Discussion List
Help Article Resources
Categories
Popular Tags
- Formulas11,000
- Project Management4,413
- Sheets3,785
- Reports2,668
- 形式2,452
- functionality2,192
- Automations1,974
- IT & Operations1,754
- Enhancement Request1,585
- Support1,564
- Cell linking1,552
- Email Notifications1,465
- Account and User Management1,401
- Dashboards1,287
- Integrations1,248
- Conditional Formatting1,225
- Construction1,093
- API and Developers941
- Sharing and Collaboration912
- Workflows in Smartsheet887
- Manufacturing864
- Update Requests846
- Gantt View801
- Product Development799
- 附件795
If you change the \"PP01\" in your formula to [Unit]@row, then it will reference the contents of the Unit cell on the row.<\/p>
You can then use this as a column formula, though you may wish to enfold it in an IFERROR so you don't get errors on the month row at the top, for example.<\/p>
=IFERROR(COUNTIFS({1. LOS, ADR and Occupancy data Range 6}, [Unit]@row, {1. LOS, ADR and Occupancy data Range 7}, \"1\"),\"//www.santa-greenland.com/community/categories/formulas-and-functions/\")<\/p>
Hope this helps, but if you've any problems\/questions then just post! 🙂<\/span><\/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":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":111722,"type":"question","name":"Calculating a fee based on QTY delivered and total fee outstanding","excerpt":"I am looking to calculate a fee amount based on total fee and qty delivered. For example, if I have two items on a PO, but only one delivers, the Fee to be Paid would only be half of the total. If all items deliver, the \"Total Admin Fee\" would copy over to \"Admin Fee to be Paid\". In the snip below, for the highlighted row,…","snippet":"I am looking to calculate a fee amount based on total fee and qty delivered. For example, if I have two items on a PO, but only one delivers, the Fee to be Paid would only be half…","categoryID":322,"dateInserted":"2023-10-16T18:20:53+00:00","dateUpdated":null,"dateLastComment":"2023-10-17T12:23:43+00:00","insertUserID":168047,"insertUser":{"userID":168047,"name":"Stitched","url":"https:\/\/community.smartsheet.com\/profile\/Stitched","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-17T12:21:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":168047,"lastUser":{"userID":168047,"name":"Stitched","url":"https:\/\/community.smartsheet.com\/profile\/Stitched","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-17T12:21:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":3395027076,"url":"https:\/\/community.smartsheet.com\/discussion\/111722\/calculating-a-fee-based-on-qty-delivered-and-total-fee-outstanding","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/111722\/calculating-a-fee-based-on-qty-delivered-and-total-fee-outstanding","format":"Rich","lastPost":{"discussionID":111722,"commentID":400295,"name":"Re: Calculating a fee based on QTY delivered and total fee outstanding","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/400295#Comment_400295","dateInserted":"2023-10-17T12:23:43+00:00","insertUserID":168047,"insertUser":{"userID":168047,"name":"Stitched","url":"https:\/\/community.smartsheet.com\/profile\/Stitched","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-17T12:21:27+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/H3ITPEK2WVAB\/image.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/H3ITPEK2WVAB\/image.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/H3ITPEK2WVAB\/image.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/H3ITPEK2WVAB\/image.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/H3ITPEK2WVAB\/image.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/H3ITPEK2WVAB\/image.png"},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-17T12:46:33+00:00","dateAnswered":"2023-10-17T02:54:19+00:00","acceptedAnswers":[{"commentID":400259,"body":"