I need some advise on which formula I can use for a Date field that populates when a checkbox is ticked.
This field should behave a bit like a time stamp, so only when the checkbox is ticked change the date field to today.
The checkbox is used in a grid edit view, so I can't use form rules for this one.
I'm not too familiar with Pipelines, but I'm keen to give that method try.
I wrote a formula today that seems to work, but I am worried that the formula below will just update to the next following everytime the record updates. Is there any other workarounds for this formula?