libreoffice.calc formula to apply current date to individual rows.

littlejoe5 · 12-02-2016, 02:12 PM

I'm having an awful time with formulas in libreoffice.calc.

I'm trying to set a column in libreoffice.calc to keep a record of entries or changes by row. The formula I've put together doesn't to anything that I can see.

This 'spreadsheet' has little to do with numbers, but rather with contacts. What I need is a formula to put a date in one column (year,month,day) for each line when it is entered, and update when anything in that row is changed.

So-far nothing that I have tried even produces a date. "=DATE" "=TODAY"

dolphin_oracle · 12-02-2016, 02:30 PM

usually functions end in ()

Code:

=today()

DavidMcCann · 12-03-2016, 11:01 AM

Download the user guide and it will tell you all you'll ever need to know!
https://wiki.documentfoundation.org/...alcGuideLO.pdf

Steve R. · 12-03-2016, 11:25 AM

Quote:

Originally Posted by littlejoe5

This 'spreadsheet' has little to do with numbers, but rather with contacts.

A misuses of what a spreadsheet is supposed to be about. A better approach would be to use a database.

DavidMcCann · 12-04-2016, 10:51 AM

The best approach is always to use what's most convenient for you, and a spreadsheet can be perfectly adequate for simple data, as any Lotus-1-2-3 veteran knows!