# To make filter and sum amount **URL:** \ **Category:** Ask for Help\ **Created:** [July 18, 2022, 3:28am UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690 "2022-07-18T03:28:55Z")\ **Posts on this page:** 8\ **Page:** 2
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 21, 2022, 2:53pm UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/21 "2022-07-21T14:53:53Z")
I think you are missing the point. User Specific Columns will work just fine for your purpose with anonymous users. ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [July 21, 2022, 3:08pm UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/22 "2022-07-21T15:08:13Z")
![1658415888082](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/6/a6c1a7ba4050913e18f8b6afc94e7fa20bb3511f.jpeg) ![1658415888064](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/e/3efb95600f38e09e0f1d7bc1b02f8815ccb00847.jpeg) ![1658415888073](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/e/fefa39f44bda9b00da80e09addb24c3b0d98614d.jpeg) ![1658415888090](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/6/f6147e8e055039a0e4ecfa691630f2551a9eafc8.jpeg) I tried to imitate from the clip but WRITE to the same sheet (people) name “gender\_filter”. On the right column is “if-then-else” formula that check gender column with “gender\_filter” column. I understood that they are on the same record. But IF I use if-then-else outside the same sheet. It doesn’t work. Please help. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 21, 2022, 3:19pm UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/23 "2022-07-21T15:19:00Z")
Okay, two things: - Firstly, your Gender Filter column is not User Specific. You need to delete that, and create it again as a User Specific column. - Once you’ve done that, create a Single Value column. This column will take the value in the Gender Filter column and apply it to all rows. You can then use this column in your if-then-else column. Also, I’d recommend changing your if-then-else column slightly, as follows: - If Single Value Gender Filter is empty, then true - If Single Value Gender Filter is Gender, then true The effect of this change is that if a user hasn’t selected a filter choice, then all records will be shown. ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [July 21, 2022, 3:46pm UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/24 "2022-07-21T15:46:56Z")
Wonderful. It works. Thank you all of you. Anyway, I still have one more thing to complete. If I want to sum all amount (price) after filter in the checked column. How to do next? I tried to use rollup, merge, array or even Match alreay. Thanks. ![1658418230210](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/b/bb44842b13bb7b6aa504ea36239ee7f3e8798844.jpeg) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 21, 2022, 3:50pm UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/25 "2022-07-21T15:50:17Z")
A simple way would be to change your if-then-else column: - If Single Value Gender Filter is empty, then Price - If Single Value Gender Filter is Gender, then Price And then you can do a rollup on that column. If you do that, you’ll just need to adjust your Inline List filter so that it checks the if-then-else column for empty/not empty. I guess one thing I should mention is that if you have any rows where the Price is empty, then the above method will mess up your filtering. So it’s probably better to create a separate if-then-else column just for the purpose of the rollup sum. ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [July 22, 2022, 1:51am UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/26 "2022-07-22T01:51:04Z")
Thank you so much. Your team is great. ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [July 22, 2022, 8:05am UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/27 "2022-07-22T08:05:14Z")
Hi. Is it possible to transfer data from one sheet to another? I want to transfer data to submit in another form and another sheet. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 22, 2022, 8:08am UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/28 "2022-07-22T08:08:38Z")
The usual way to do this is to create a single relation between the two tables, and then use one or more lookup columns to fetch the column values that you need in the second table. [Previous page](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690.md?page=1)