0

when I import a range, in Google Sheets, or I use the formula Filter(), I get an array of data. I would want to then be able to edit the imported/filtered data, is that doable? of course, without having to manually paste the data elsewhere (using paste special)

Today, when I click on a cell to edit, I get the formula and not the value

Better yet, is there a formula that can import only the values? I understand that in such a situation the link between the Source and the Destination will be broken, but that is fine

  • 1
    I don't think this is doable, but you can always try to automate the copy/paste values so it is not manual – Oren Pinsky Oct 11 at 0:50
  • 1
    Welcome. It's not clear what you mean by "when I click on a cell to edit, I get the formula and not the value" but anyway, You can't have your cake and eat it – Rubén Oct 11 at 1:11
  • 1
    thank you Rubén for pointing to the right question!! – Sam Toufaili Oct 11 at 16:40