ContributionsMost RecentMost LikesSolutionsRe: Share your feedback on the new Qrew Discussions While I wouldn't describe it as awful, annoying would be my word, I experience the same thing. Every time i come here, I get the cookie popup. Pie Chart Help I have a list of "Project Types". Attached is a summary report of this table and field. But, I really want to show it in a Pie Chart. Specifically, I want "Commercial EPR New Build and "Commercial NewBuild" grouped into one category and then all others in a "Other" category. I am thinking a report formula using the Count function. Is that right? Moving data from a columnar table to a record based table Not sure that's a great title, but it's the best I could come up with right now. I created the below table for ease of end-user data entry. (To increase adoption rate and reduce pushback.) I would like to create fields/or a table, that would basically take the column headers and the associated numbers into the more useful table that has a multiple choice field for offense type, the date and # in the column. I believe this is very doable, but I am just drawing a blank tonight. Re: Pull a number from another table The QB action worked, but its fairly unwieldy and I see issues with it. i.e. If someone incorrectly enters a number and goes back to edit. the edit wouldn't be reflected in table 2. So, I guess I will try my hand at a Formula Query. However, I do have one more thing in mind that might make this even simpler. in table 1, I have two types of calls, EMS calls and Fire calls. I could add ESD 7 as a type of call and maybe that would solve my problems. Let me try that and get back to you. ------------------------------ Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase) IT Director City of New Braunfels ------------------------------ Re: Pull a number from another table I think so. Total FD Calls in table 2, first record, should be 1,073. That is the total of the Fire and EMS calls for Nov 2023. It really could be in any of the 17 entries on table 2 that are dated in November. I just need to be able to calculate the total number of ESD 7 calls, regardless of Incident Type, by Total FD Calls. ------------------------------ Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase) IT Director City of New Braunfels ------------------------------ Re: Pull a number from another table Wait, maybe I can just do this with a QB action. When a new entry is made in table 1, just copy that record to table 2. Only copy date and Total calls fields. ------------------------------ Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase) IT Director City of New Braunfels ------------------------------ Re: Pull a number from another table Not exactly sure how to answer that. Here is a screenshot of some data from Table 1. I want to bring total calls over. (The dates won't always match up in Table 2, but the month is the important piece.) Data in table 2 currently looks like this... There wouldn't be an incident type, just a date and total FD calls. ------------------------------ Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase) IT Director City of New Braunfels ------------------------------ Re: Pull a number from another table OK Mark, I am raising the flag for help. I can't get this done right. I do just simply want to bring a number from field 1 in table 1, to a similarly titled field in table 2. I know this is easier than I am making it out to be. How do I do this? The tables are in the same app. ------------------------------ Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase) IT Director City of New Braunfels ------------------------------ Re: Pull a number from another table Thanks, Mark and Chayce. That's some really great info. I think this one is simple enough to just do a table to table relationship and bring that total over to table 2 and be done with it that way. Neither table is huge like you describe Mark, but this is likely just the easiest and quickest way. Was just hoping maybe there was a simpler formula way to do this. No worries. I think i can make this happen. ------------------------------ Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase) IT Director City of New Braunfels ------------------------------ Pull a number from another table I ahve a table that breaks down "Fire Calls" in table 1. I have table 2 that needs to have a formula of "total of fire calls" divided by ESD 7 calls. I haven't had to pull numbers from another table up to this point. I am going to look in help and other resources, but I always think this group will be faster or add clarification. ------------------------------ Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase) IT Director City of New Braunfels ------------------------------