ContributionsMost RecentMost LikesSolutionsRe: Multiselect text to reportOk- so I just tried it out with 4 values. This is what is coming up. I think on the right track, but I need to know how many of each item was used each month and this only does the total. I uploaded what the report is showing and the settings I have. Whenever you have a chance let me know if you have any suggestions for me haha, I'm probably missing something silly. Re: Multiselect text to reportOk got it, so then I just repeat that with each different item? Thank you for walking me through this haha! And then how would I set the report up?Re: Multiselect text to reportI just copied yours, right? If(Contains(ToText([my multi select field], "chapstick�)),1,0) Re: Multiselect text to reportOk, when I do that it says this error message Formula syntax error Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets. Re: Multiselect text to reportOk- I don't have any idea how to do that/where. I can try to do some investigating but I really only know how to do simple forms/reports.Re: Multiselect text to reportMaybe not even.Re: Multiselect text to reportProbably like 11 or so.Re: Multiselect text to reportIs there any other way to set it up so that it's just one table? Sorry I'm new to this but that seems complicated/ above my understanding level.Multiselect text to reportQuestion from a QB newbie. I am creating a form for patient bags we give out to patients. I have it set up asking the following questions: Date given (date), Patient name (text), Contents in bag (multiselect text with each of the items- chapstick, icescraper, phone charger etc). The goal of this form will be to keep track of who has received bags but more importantly to track how much of each item we are using each month. For example, we put chapsticks in each bag. So for the month of October we want to be able to see how many chapsticks we've given out for ordering purposes. Does anyone have any ideas on how to make this work in a report? I am having issues getting the report to reflect that information. Is there a better way to set this up?How do I create a new dashboard for ""everyone on the internetDisclaimer: I am new to QB and know nothing about coding. How do I create a new dashboard for "everyone on the internet" like a landing page for employees to submit a request form? One that is different from the default dash?