Rpsu (326 ppm)

Wouldn't it be nice if one could declare variable or constants in a formula in Google Sheet? Define something once and reuse it multiple times within one formula.

= declare(VAR=(if(A="";B;A))&&right(VAR,len(VAR))

(And directly in the sheet, not via apps script.)

#googlesheet #semiprogrammer #programming

sheislaurence

🧵 2/4: in the meantime, it was extraordinary to see how people were getting organised: using #publicposting strictly for maximum reach, creating an editable #Googlesheet of #missingpeople docs.google.com/spreadsheets/d, posting pix of #pets founding running on the road.. Thanks to the spreadsheet and #Facebook, I was finally able to find out that the person I know in #Lahaina is safe 🙏🏽

TechHelpKB.com 📚

If your #Workspace edition supports it, you may mail merge from #Gmail using a #GoogleSheet as your data source. This allows you to create an #email that takes custom fields from a spreadsheet and insert them into individual emails. tchlp.com/44RBPss

How To Integrate Google Sheets With Mail Merge in Gmail

Learn how to integrate Google Sheets with mail merge…

tchlp.com
Ike

@Emmie12750 @andricheli Yeah following people from other instances isnt intuitive and a quite bumpy workflow. I hope that is a product workflow that gets smoothed out soon.

I tried doing a hashtag search for my city and found a few posts but maybe this list of Journalists on Mastodon would be helpful: docs.google.com/spreadsheets/d #GoogleSheet

Journalists on Mastodon and Fediverse (Responses) - Google Drive

docs.google.com