Hi,
I am trying to get a column that provides the Date (easy with Record a Date) but I need the TIME as well. Most of my tables I just use the right function on the Modified Date because the only thing updating those tables are automations or data imports. But a few tables have automations, data imports, and manual inputs. For those tables, I only want to know the date of when a manual input is completed (i.e. when the modified by field is a person, not a cell-line@smartsheet.com).
It's easy to say "when any field changes"…"record a date"…if "Modified By" is not cell-link@smartsheet.com.
I need a way to add a "record a time" or something. I tried to use "change a cell value" and use smart tags like {{Modified}} to grab that field and drop it there, it did not work.
What else can I do?
