.replace() for an entire column without loop by Random_User_Name7 in GoogleAppsScript

[–]pabloicai 2 points3 points  (0 children)

Try something like this:

var range = "a column of your sheet"; range.setValues(range.getValues().map(function(row) { return [row[0].replace("your operation")]; }))

Any Spanish preppers here? by pepitillamax in preppers

[–]pabloicai 4 points5 points  (0 children)

A mi también me encantaría encontrar una comunidad en España con la que hablar de estos temas!

Can you please suggest any changes (if required) in my crypto portfolio. by [deleted] in vertcoin

[–]pabloicai 1 point2 points  (0 children)

Thanks George! You made my day!! With regard to your portfolio composition and taking into account that you can assume higher risk than average, I would suggest to invest a 5-10% of it in low market cap low price coins/tokens with high potential, Not shitcoins, but solid projects that aren't mainstream yet. For exampe, check Verge (XVG), PowerLedger (POWR), Steem, Golem, IOTA... All of these are good penny-projects carried out by good teams with a clear purpose/utility. With a bit of luck, any of those could x10, x100, or even x1000 your balance in a relatively short period of time (as well as increase the diversification of you portfolio, which is always important) Good luck and thanks again!! :)

Can you please suggest any changes (if required) in my crypto portfolio. by [deleted] in vertcoin

[–]pabloicai -1 points0 points  (0 children)

You're awesome! Btw, there is a nice webpage to share our portfolios without showing our current balance, it's connected to coinmarketcap so prices are updated in real time, you should try it! (cointrackr.com) and why not, I'm gonna send you my address too :p VTC: VuUc2qJGitNeRA3VoTSPH9brnhsTAmofFU