title: Sorting Values in Google Sheet using loop in Google Apps Script
body: <p>I am trying to create a function in Google Sheets using Google Apps Script.</p>
  
  <p>I have a list of 300 values in Sheet 1, Column A.</p>
  
  <p>I have a formula which needs to be applied on each value (in Column A), one by one. </p>
  
  <p>The output of the formula should be "Select" or "Reject".</p>
  
  <p>I am able to do it manually, but I need it to be automated using Google Apps Script.</p>
  
  <p>I have numbers in Column A and I want to find their square root in Cell B2, row by row. When the square root is greater than a defined value, the original number should get listed in column C, while numbers without a square root greater than the defined value should be listed in column D (See example below).</p>
  
  <p><a href="https://i.stack.imgur.com/JEVqN.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JEVqN.jpg" alt="enter image description here"></a> </p>