This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackDone
Hi...very interesting challenge. I used a rather long approach I first looked up the data sheets using and find and replace and filtered it with the date(since June confused me as well) after that I concatenated the orders for each Ticket I'd and filtered unique tickets. I used a filter tool to filter out potential meal. And then used formula tool to get the final result. It was incredible to see the easier logics applied by others something that I would use in future challenges probably
Always fun doing these. I learned the actual operation of Contains() formula which was giving me for no reason a lot of trouble. I also find it interesting so the different ways this can be completed. I do think though that when it says since June 2013 it should be clarified to say since July 1, 2013. I read it as June 1, 2013 and ended up with a different answer. I didint want to open the full solution workflow and ended up spinning my wheels for too long to try and resolve what was not a flow issue but a clarificaiton issue.
In the future I think the terminology should be as specific as possible since we arent in a client meeting with the ability to get explicit answers in situations like these