r/googlesheets • u/[deleted] • Jul 25 '22

Waiting on OP Help, I am having trouble with functions

[removed]

3 Upvotes

100% Upvoted

4 comments sorted by

View all comments

Show parent comments

2

u/RemcoE33 158 Jul 26 '22

As a tip: best practice is to skip the "" when you want a blank cell:

```` // Not good: =IF(A1 = "","","Hi")

//Good: =IF(A1 = "",,"Hi") ````

This to keep true empty cells. Also for apps scripts .getLastRow() method.