Drop Down List

SHJAM

Does any one know how to add a date and comments in the same field.  For example - "08/15/2018 Left Message".  I want the date of the activity to be documented in 1 field.

Joy Durham

It would have to be a text/number type column (which is the default)

Charles DESCOTES

Use 3 columns:

1. with the date (for instance called "Date")

2. with the text comment (for instance called "Comments")

3. concatenate, using +

=Date25 + " " + Comments25

(for instance for row #25)

the + " " is only to insert a space in between.

Suiting your need?

Jose da Silva

Or in alternative, use the comments option on the left side of the spreadsheet

J. Craig Williams

If you don't need to access the date (in metrics for example), this will also work.

key strokes:

t

enter

reselect

f2

add text

Craig