# Autocomplete of cells **URL:** \ **Category:** Ask for Help\ **Created:** [March 15, 2021, 11:35am UTC](https://community.glideapps.com/t/autocomplete-of-cells/24283 "2021-03-15T11:35:14Z")\ **Posts on this page:** 1\ **Showing post:** 4
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [March 15, 2021, 12:00pm UTC](https://community.glideapps.com/t/autocomplete-of-cells/24283/4 "2021-03-15T12:00:19Z")
Quick example =IF(ISBLANK(M2:M),“Delivery”,“Delivered”) M2:M is the range “Delivery” if value if true “Delivered” if value is false Read this if you want to put an array in the column header. This will auto populate any new rows added to your sheet > [@Using ARRAYFORMULA()'s in Row 1 of your Spreadsheet](https://community.glideapps.com/t/using-arrayformula-s-in-row-1-of-your-spreadsheet/529): > > I can’t take credit for this tip but I just found out about this trick/tip by reading a post [here](https://community.glideapps.com/t/if-user-deletes-1st-row-he-loses-array-formula/246). So the “Normal” way of using an ARRAYFORMULA function is to use it in row 2 of a given column. You just have to be careful not to accidentally deleted it, or have a user delete it. So the next idea was to put it in row 2 but not put any other data in the row and then hide or minimize that row. Basically your data for the non ARRAYFORMULA columns would start on row 3. Then I saw the post I’ll l… --- _[View the full topic](https://community.glideapps.com/t/autocomplete-of-cells/24283)._