# Automatically filled **URL:** \ **Category:** Ask for Help\ **Created:** [April 19, 2020, 12:27pm UTC](https://community.glideapps.com/t/automatically-filled/7369 "2020-04-19T12:27:26Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![Adalberto\_Ponzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adalberto_ponzo/32/3657_2.png) [@Adalberto\_Ponzo](https://community.glideapps.com/u/Adalberto_Ponzo)\ **Post date:** [April 19, 2020, 12:27pm UTC](https://community.glideapps.com/t/automatically-filled/7369/1 "2020-04-19T12:27:26Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b1f65c2c0b7af1a2efcc019814888611626908c4.png) I have this spreadsheet and the formulas seem to work correctly, depending on the value of each column the column “F” is filled with the highest value. How to make the column “F” be filled automatically without dragging the formula from the previous cells? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 19, 2020, 12:51pm UTC](https://community.glideapps.com/t/automatically-filled/7369/2 "2020-04-19T12:51:21Z")
Use an ArrayFormula…they’re magic! [https://support.google.com/docs/answer/3093275?hl=en](https://support.google.com/docs/answer/3093275?hl=en) ---
**Author:** ![Adalberto\_Ponzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adalberto_ponzo/32/3657_2.png) [@Adalberto\_Ponzo](https://community.glideapps.com/u/Adalberto_Ponzo)\ **Post date:** [April 19, 2020, 2:59pm UTC](https://community.glideapps.com/t/automatically-filled/7369/3 "2020-04-19T14:59:51Z")
I had thought about it, but I couldn’t make the formula, but it seems that this way it worked: =ARRAYFORMULA(SE(B2:B\>C2:C;SE(B2:B\>D2:D;SE(B2:B\>E2:E;B2:B;E2:E);D2:D);C2:C)) Thanks ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 19, 2020, 6:43pm UTC](https://community.glideapps.com/t/automatically-filled/7369/4 "2020-04-19T18:43:48Z")
That looks correct! ---
**Author:** ![Adalberto\_Ponzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adalberto_ponzo/32/3657_2.png) [@Adalberto\_Ponzo](https://community.glideapps.com/u/Adalberto_Ponzo)\ **Post date:** [April 19, 2020, 7:41pm UTC](https://community.glideapps.com/t/automatically-filled/7369/5 "2020-04-19T19:41:21Z")
Something is wrong, I saw that if the order of values it is not sequential it does not respect the formula, it takes the value of the sequence and not the bigest value, I imagine that some comparison is missing, as shown in the image below. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/082b35919cf40806e71fed09239d974f2b99f0c1.png) ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 19, 2020, 9:04pm UTC](https://community.glideapps.com/t/automatically-filled/7369/6 "2020-04-19T21:04:46Z")
AH…you want max. I missed that. Tricky to do in array (max per row). I found this online…it shoudl work for you (replace A2:E with the range of values): ```auto =query(transpose(query(transpose(A2:E),"Select "®EXREPLACE(join("",ArrayFormula(if(len(A2:A),"Max(Col"&ROW(A2:A)-ROW(A2)+1&"),",""))), ".\z","")&"")),"Select Col2") ``` ---
**Author:** ![Adalberto\_Ponzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adalberto_ponzo/32/3657_2.png) [@Adalberto\_Ponzo](https://community.glideapps.com/u/Adalberto_Ponzo)\ **Post date:** [April 19, 2020, 9:28pm UTC](https://community.glideapps.com/t/automatically-filled/7369/7 "2020-04-19T21:28:52Z")
I’ll try, it looks complicated Thanks ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 19, 2020, 9:39pm UTC](https://community.glideapps.com/t/automatically-filled/7369/8 "2020-04-19T21:39:12Z")
Ya…I only partly understand it myself…but it works! ---
**Author:** ![Adalberto\_Ponzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adalberto_ponzo/32/3657_2.png) [@Adalberto\_Ponzo](https://community.glideapps.com/u/Adalberto_Ponzo)\ **Post date:** [April 19, 2020, 11:33pm UTC](https://community.glideapps.com/t/automatically-filled/7369/9 "2020-04-19T23:33:48Z")
I still haven’t managed to make it work, tomorrow I will continue. ---
**Author:** ![Adalberto\_Ponzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adalberto_ponzo/32/3657_2.png) [@Adalberto\_Ponzo](https://community.glideapps.com/u/Adalberto_Ponzo)\ **Post date:** [April 20, 2020, 12:39pm UTC](https://community.glideapps.com/t/automatically-filled/7369/10 "2020-04-20T12:39:29Z")
Good morning Robert, I think I’m not making myself understood, maybe this formula doesn’t suit me, I don’t need the highest value in the matrix, but rather the highest value in a line that may or may not contain values. Thanks ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 20, 2020, 1:09pm UTC](https://community.glideapps.com/t/automatically-filled/7369/11 "2020-04-20T13:09:43Z")
The formula I sent is per line. Want to share your sheet with me and I’ll take a look? ---
**Author:** ![Adalberto\_Ponzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adalberto_ponzo/32/3657_2.png) [@Adalberto\_Ponzo](https://community.glideapps.com/u/Adalberto_Ponzo)\ **Post date:** [April 20, 2020, 1:42pm UTC](https://community.glideapps.com/t/automatically-filled/7369/12 "2020-04-20T13:42:29Z")
no problem, give me your email. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 20, 2020, 2:14pm UTC](https://community.glideapps.com/t/automatically-filled/7369/13 "2020-04-20T14:14:39Z")
Done. Forgot that commas and semicolons are reversed in formulas in other countries: ![Screen Shot 2020-04-20 at 10.13.38 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/530e3b33ccce005232f5d79432a402b9bd2a8b03.png) ---
**Author:** ![Adalberto\_Ponzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adalberto_ponzo/32/3657_2.png) [@Adalberto\_Ponzo](https://community.glideapps.com/u/Adalberto_Ponzo)\ **Post date:** [April 20, 2020, 2:24pm UTC](https://community.glideapps.com/t/automatically-filled/7369/14 "2020-04-20T14:24:26Z")
Robert, thank you so much I don’t know how to thank you, you are the best, I have so much to learn. ---
**Author:** ![Adalberto\_Ponzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adalberto_ponzo/32/3657_2.png) [@Adalberto\_Ponzo](https://community.glideapps.com/u/Adalberto_Ponzo)\ **Post date:** [April 22, 2020, 2:34pm UTC](https://community.glideapps.com/t/automatically-filled/7369/15 "2020-04-22T14:34:50Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f835ccd930e2a6515c3d8c3376610ab8d8d430aa.png) [https://docs.google.com/spreadsheets/d/1TA-N8YDtqxkEWuBQEUoIFfzVa3putIlK3dfSMxHpHJk/edit#gid=0](https://docs.google.com/spreadsheets/d/1TA-N8YDtqxkEWuBQEUoIFfzVa3putIlK3dfSMxHpHJk/edit#gid=0) Good morning Robert, sorry for bothering you, I thought I had solved my problem, but to my surprise when I went to put the formula in the work spreedsheet the result was not what was expected, did I do something wrong? Thank you for your attention, Thanks ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 22, 2020, 2:38pm UTC](https://community.glideapps.com/t/automatically-filled/7369/16 "2020-04-22T14:38:14Z")
The formula only works if the columns containing the number values the are next to each other…spreading them out like you have it will break the formula (and really isn’t best practice for doing any sort of calculation). ---
**Author:** ![Adalberto\_Ponzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adalberto_ponzo/32/3657_2.png) [@Adalberto\_Ponzo](https://community.glideapps.com/u/Adalberto_Ponzo)\ **Post date:** [April 22, 2020, 2:50pm UTC](https://community.glideapps.com/t/automatically-filled/7369/17 "2020-04-22T14:50:57Z")
thanks for the valuable information, sorry. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 22, 2020, 5:39pm UTC](https://community.glideapps.com/t/automatically-filled/7369/18 "2020-04-22T17:39:31Z")
No worries. If you need further assistance, just let me know.