Google Form Vote Counter

[Kagami]

Make a vb function that writes "hammer" to an arbitrary cell. Mod deletes the message on new day

[Kagami]

2 can be done with straightforward string manipulation functions

[Kagami]

Doing 1 with a typical formula is impossible (I think), because excel wants doesn't want to have its current state be dictated by anything other than what it currently is. The solution is to write a VBA formula that says something like "If <cell> > <threshold> Then <hardcoded cell index> = "HAMMER!".

If I understand 2, it can be done with string formulas. It's just going to end up being a giant set of &s, ifs, and maybe some string trimming.

[Kagami]

Aa, I see what you're saying, you want to keep a snapshot of all the VCs as they occur.

One solution is very similar to 1, you'll need to write a VBA function that looks for a specific range of cells, finds where the historical VCs end, pushes them all down, then writes the current VC to the top.

[Kagami]

I'm thinking in excel, btw. I just realized we're talking about sheet, and I'm not really sure how scripting works there.

[Kagami]

function writeToMagicCell() {
SpreadsheetApp.getActiveSheet().getRange('K6').setValue('o hi there');
}

^ this is the kind of thing you'll have to do.