Can I have a cell that displays when another cell containing a checkbox was 'checked' or 'unchecked'?
Got a tip for us? Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
Numbers When Checkbox checked
- Thread starterjdw13
- Start date
- Sort by reaction score
Maybe I don't get what you are saying, but I don't want to test the state of the cell at the current time, but I want to record when the state of the cell 'CellWithCheckBox' changed.
Maybe.
If you format one cell as a checkbox, then set another cell to monitor that cell you can get this.
For example, Format A1 to be a checkbox. This returns True when checked and False when not checked. Checking the checkbox updates the sheet.
Another cell has the function If(A1,NOW).
When the cell is checked this displays the time and dates it was checked. Otherwise it displays “False”.
You can have any number of checkboxes. Only the cells that are checked will show the updated time. The others will display “False”.
If multiple boxes are checked then checking a third will update the times for all of the checked boxes.
I don’t see an easy way around that. Maybe this is sufficient for you.
If you format one cell as a checkbox, then set another cell to monitor that cell you can get this.
For example, Format A1 to be a checkbox. This returns True when checked and False when not checked. Checking the checkbox updates the sheet.
Another cell has the function If(A1,NOW).
When the cell is checked this displays the time and dates it was checked. Otherwise it displays “False”.
You can have any number of checkboxes. Only the cells that are checked will show the updated time. The others will display “False”.
If multiple boxes are checked then checking a third will update the times for all of the checked boxes.
I don’t see an easy way around that. Maybe this is sufficient for you.
Thanks, but unfortunately I am looking to have a column of check-boxes and have a neighboring column show when each is checked. Your idea would work if we had an option on NOW() call to not update once it is set. For a moment I thought that perhaps the pull-down "Show Function as Text" would do that, but it does not 'freeze' the value.
One way to do what I want manually is, right after checking the "check-box-cell" so the "time-cell" is now showing time, to then immediately copy the time-cell (with command-C) and then paste it into itself with "Command-Shift-V". This also turns the time-cell to text so it will not provide the function anymore if the check-box is unchecked.
One way to do what I want manually is, right after checking the "check-box-cell" so the "time-cell" is now showing time, to then immediately copy the time-cell (with command-C) and then paste it into itself with "Command-Shift-V". This also turns the time-cell to text so it will not provide the function anymore if the check-box is unchecked.
Last edited:
