If I have a change timestamp that set to watch more than one column, how would they trigger the change timestamp?
Example :
Watched column : A , B, C
Which one of this will happen :
1. The change in A or B or C will trigger the change timestamp
2. The change in A and B and C together will trigger the change timestamp
It is option 1 you described.
So, if I would like to have the change timestamp triggered only after column A dan B and C change altogether, what should I do?
One option to try will be to create a datetime type column instead of ChangeTimestamp column.
For this datetime type column, please have an app formula expression of
IF(AND([_THISROW_BEFORE].[Column A]<>[Column A], [_THISROW_BEFORE].[Column B]<>[Column B], [_THISROW_BEFORE].[Column C]<>[Column C]),NOW(),[_THIS])
Please leave initial value as blank for this column. Please test well.
Option #1 with OR()
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |