I have a check box column and then I have a column next to it where I want the timestamp to be entered on when the box was checked. I was able to get it to work with now() in the formula, but that date and time is not maintained, but instead stays current which I guess is the point of the now() formula. I have also attempted modified() in the formula, but then it puts a date/time in every row of the column not just the ones that have been checked. How do I get it so when the box is checked the current date and time is entered in the second column, but remains static and the rows where the box is not checked remains blank? I was wondering if maybe it would be possible to use the now() formula to get the current date/time and then have it converted to text so it doesn’t change?
Any help would be appreciated.