# Solved **URL:** \ **Category:** Ask for Help\ **Created:** [September 5, 2020, 1:58am UTC](https://community.glideapps.com/t/solved/15299 "2020-09-05T01:58:52Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [September 5, 2020, 2:05am UTC](https://community.glideapps.com/t/solved/15299/2 "2020-09-05T02:05:18Z")
Check out this post: [Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727) Basically, you have to create an IF formula to check if there’s a value in a specific column (usually the 1st one) in order to conditionally perform the calculation, or leave the cell blank. --- _[View the full topic](https://community.glideapps.com/t/solved/15299)._