Hi all,
I was wondering how to achieve the following:
column A(text) and B(date), how to work that when A be changed, than set
B date(TODAY)
Is there a way to achieve this?
Thanks in advance.
if this is the only use of B, then the simplest way would be to make B a Change Timestamp column.
Hi @praveen, Sorry , I saw your post after posting my
comment that I was typing in, so did not realise you had already posted.
@Suvrutt_Gurjar @praveen thanks you guys itโs worked!
Hi From
your description and my understanding, I request you to try following ,
Column
C with column type as โChangeTimestampโ
and please set change column to โColumn Aโ
in Column Cโs definition. You can also hide this column C
2)Please insert expression =LEFT(TEXT([Column C]),10) in Column B
and please define column B as Text type.
When there is a change in Column A , you will see that Column B shows todayโs date.
However,in this scheme, once the date has changed with first change for the day in Column A
, it will remain same till next day, in spite of any number of changes in Column A.
Hope this helps.
User | Count |
---|---|
40 | |
29 | |
22 | |
20 | |
15 |