Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
Formulas by today's date
I am able to figure out the fomula to count these items individual but i am running into trouble getting the correct format if i want to count # of clients that came in based on today's date at the specific location. Any help is greatly appreciated.
Comments
-
Benjamin Walker Employee(If this image is too small for you try right clicking it and opening it in a new tab)
Try this. This counts the location and specified date. It can definitely be modified to better suit your needs!
The formulas I came up with are:
=COUNTIFS(Location:Location, "Retail", Date:Date, Date2)
or
=COUNTIFS(Location:Location, "Retail", Date:Date, DATE(2017, 1, 24))
Categories
I hope you're well and safe!<\/p>
Try something like this.<\/p>
=IF(Acreage@row <> \"//www.santa-greenland.com/community/discussion/7049/\", IF(Acreage@row < 1, 1))<\/p>
Did that work\/help? <\/p>
I hope that helps!<\/p>
Be safe, and have a fantastic weekend!<\/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>"}]}},"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":108252,"type":"question","name":"I would like to count the total values from a multi select column, based on another columns criteria","excerpt":"I apologize but I cannot seem to wrap my head around this. My goal is to count the total values in a multi select column based on another columns criteria. I figured I could combine the use of CountM and CountIFS but I have not been successful. Here is an example. The goal is for me to determine the total # of Reps Per…","snippet":"I apologize but I cannot seem to wrap my head around this. My goal is to count the total values in a multi select column based on another columns criteria. I figured I could…","categoryID":322,"dateInserted":"2023-07-28T15:05:34+00:00","dateUpdated":"2023-07-28T15:25:29+00:00","dateLastComment":"2023-07-28T15:56:23+00:00","insertUserID":164265,"insertUser":{"userID":164265,"name":"Jeremy J.","title":"Specialist","url":"https:\/\/community.smartsheet.com\/profile\/Jeremy%20J.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T15:56:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":164265,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-28T15:52:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":25,"score":null,"hot":3381118317,"url":"https:\/\/community.smartsheet.com\/discussion\/108252\/i-would-like-to-count-the-total-values-from-a-multi-select-column-based-on-another-columns-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108252\/i-would-like-to-count-the-total-values-from-a-multi-select-column-based-on-another-columns-criteria","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":108252,"commentID":387843,"name":"Re: I would like to count the total values from a multi select column, based on another columns criteria","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387843#Comment_387843","dateInserted":"2023-07-28T15:56:23+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-28T15:52:49+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\/DN3IR3WTNK71\/for-smartsheet-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"For SmartSheet.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-28T15:50:27+00:00","dateAnswered":"2023-07-28T15:47:11+00:00","acceptedAnswers":[{"commentID":387835,"body":" You would use a COUNTM\/COLLECT combo.<\/p> =COUNTM(COLLECT(Rep:Rep, Manager:Manager, @cell = [Manager (For Formula)]@row))<\/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":108233,"type":"question","name":"Change Date column if new row is added after hours","excerpt":"Hello - We have a simple ticket system and if a ticket request from a form comes in after 4:00pm, we don't start the ticket until the next day. Case: Form Entry happens at 2:30pm on 07\/27\/23. Start Date column should read 07\/27\/23. Form Entry happens at 4:30pm on 07\/27\/23. Start Date column should read 07\/28\/23. So we want…","snippet":"Hello - We have a simple ticket system and if a ticket request from a form comes in after 4:00pm, we don't start the ticket until the next day. Case: Form Entry happens at 2:30pm…","categoryID":322,"dateInserted":"2023-07-27T23:02:48+00:00","dateUpdated":null,"dateLastComment":"2023-07-28T15:22:11+00:00","insertUserID":155331,"insertUser":{"userID":155331,"name":"MHalvey","url":"https:\/\/community.smartsheet.com\/profile\/MHalvey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5XN473Z9AXCW\/nOE57ZX9L8KLD.png","dateLastActive":"2023-07-28T16:35:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-28T15:52:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":23,"score":null,"hot":3381058499,"url":"https:\/\/community.smartsheet.com\/discussion\/108233\/change-date-column-if-new-row-is-added-after-hours","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108233\/change-date-column-if-new-row-is-added-after-hours","format":"Rich","tagIDs":[227,254,277,334,369],"lastPost":{"discussionID":108233,"commentID":387817,"name":"Re: Change Date column if new row is added after hours","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387817#Comment_387817","dateInserted":"2023-07-28T15:22:11+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-28T15:52:49+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-28T14:18:14+00:00","dateAnswered":"2023-07-28T00:16:33+00:00","acceptedAnswers":[{"commentID":387714,"body":" You would need to leverage the Created Date column and a formula that will evaluate the time and add 1 to the date.<\/p> =DATEONLY(Created@row) + IF(AND(FIND(\"P\", Created@row)> 0, VALUE(MID(Created@row, FIND(\" \", Created@row) + 1, FIND(\":\", Created@row) - (FIND(\" \", Created@row) + 1))) >= 4, VALUE(MID(Created@row, FIND(\" \", Created@row) + 1, FIND(\":\", Created@row) - (FIND(\" \", Created@row) + 1))) < 12), 1, 0)<\/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":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":369,"urlcode":"bridge-by-smartsheet","name":"Bridge"}]}],"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":[]}">
