Sign in to join the conversation:
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.
It would have to be a text/number type column (which is the default)
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?
Or in alternative, use the comments option on the left side of the spreadsheet
If you don't need to access the date (in metrics for example), this will also work.
key strokes:tenterreselectf2add text
Craig
Hi All I have created a support request form and sheet to allow functions to request support from my team. When a request comes in, it is assigned a unique support ID number. I then assign the request to a member of the team vias drop down. I have added an automation to message the requester when a team member has been…
Is there a way to add a column that updates with the last comment entered into the conversations from that row? For example: If I entered notes from a call that I had with a client "conversation went well, will follow up" that note would populate into a column on that same row labeled last comment or update. This would…
Up until yesterday (11/3/25) I was able to click on the top of a column and sort my column. This worked for me yesterday morning but when I went in to work in the afternoon I was not able to sort columns anymore. Also it seems my filters are not working. I am not the admin for this sheet but the admin is saying nothing has…
