-
• #3
i love a bit of concatenation myself
-
• #4
i love a bit of concatenation myself
I've spent about 2 hours this morning concatenating crap with simple formulas.
I hate this time of year. -
• #5
Anyone know if you can use O365 Typescript or whatever it's new scripting language is to add a timestamp to a column when another column's value is changed?
The 3rd comment here on a similar request suggests not possible ("There currently is no way to trigger a script run on cell/range change.")
https://stackoverflow.com/questions/70175029/dynamic-office-script-date-for-modified-row
I haven't done this in along time and searching is just giving me conflicting answers.
If a Cell in one column
something along the lines of
If Sheet 1 B1= Sheet 2 B1 then copy Sheet 2 Row 1 to Sheet 1 Row 1
Sheet 2 Row 1 to Sheet 1 Row 1 - This would be 4 colums at the end of the row.