FredK_Trashmail - profile

FredK_Trashmail · Dec 21, 2019

Hi, I would like to have a field (or at least the data) counting the number of times another field has changed. Eg calculating the number of times a task end date has been moved. Any idea ? Thank you Fred

FredK_Trashmail · Dec 30, 2019

Hi, It should be LookUp instead of Rollup. That will give you the ability to select a given table and field. Cheers Fred

FredK_Trashmail · Dec 30, 2019

Hi, DATEADD( ThatDate, VALUE(lookup value), ‘day’) shows #ERROR but DATEADD( ThatDate, lookup value +0, ‘day’) works for me. Cheers Fred

FredK_Trashmail · Dec 30, 2019

Hey, In order to do that, you first need to ensure your field is defined as text (A) and not a number (#). That should be all. Cheers Fred

User Statistics

User Activity

Counter for every time a given field is changed

Re: Showing 'Completed' Tasks Only, in Linked Table

Re: Trying to add a looked-up value and DATEADD

Re: Writing a formular on taking first four numbers of another field