I have a table table of jobs, within that table is a column for status and sub-status. There is another column of the change timestamp type that catches the timestamp each time the sub-status is changed. This is used to make sure jobs are retouched every so often. The problem is that each retouch may not warrant a sub-status change to reset the timestamp. Right now the users are having to change to a different sub-status then change back to the previous sub-status to reset the timestamp.
The research I have done, shows that actions cannot be performed of columns that use app formulas. Otherwise that would be the easiest solution.
Any recommendations would be greatly appreciated.
