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
I need to setup automations based on a contract date that will notify me on a monthly/quarterly/annual basis so I can process paperwork at the appropriate time. Ideally, I'd like to set it up to send an email 90 days before that date. I have columns for the initial contract date and the frequency (one for the word…
Hi everyone, Is there a way to set a dashboard as the default homepage for all users upon login? Ideally, we’d like users to land directly on a particular dashboard instead of the usual default page. Is this possible through configuration, or is there a plugin or workaround that can help us achieve this? Thanks in advance!
I created a "move row to another sheet" automation where the trigger is when rows are changed and ACTIVE / INACTIVE status changes to INACTIVE. When I changed the status in one row, the automation was triggered and now all of my rows are gone, and they are not on the destination sheet either. Where is my data? There is no…
