I wanna use this Arrayformula for a row (get the data from that row, and have the input also in it). =ARRAYFORMULA(IF((LEN($C1:$C100)>240),IMPORTDATA(CONCATENATE("tinyurl.com/api-create.php?" & $C1),"")))

• if the link is longer than 240 char. > to make it with tiny URL instead, it works if I put the formula on a different row, but when I try to conditional format the whole row it doesn't work / return anything, or when I use it as arrayformula it has the #REF - circular dependency error. Is there a way to solve this (apply it to the whole row, take the date from that row and return the output on it also).

  Option 1 will produce the same result as to your original formula. The option 2 will ignore the URLs below 240 characters.

  Sample:

  

  Result:

  

  If you select Tiny URL ver.2, only the URLs with more than 240 characters will be changed and the rest of the URLs remains the same instead of being replaced with FALSE