Hello,
Working on creating a long checklist. When Form Control Box is checked "completion Date & Time" is seen next to the task.
The issue seems to be every time any value is checked ALL of the time/date stamps update. Please see below:
All of the checkboxes have been linked to the respective row for Column G.
Working on developing my Excel skill/knowledge, so this might not be the most efficient and/or effective method.
Thanks
Working on creating a long checklist. When Form Control Box is checked "completion Date & Time" is seen next to the task.
The issue seems to be every time any value is checked ALL of the time/date stamps update. Please see below:
Column B Check Box (Form Control) Cell Linked: $G$9 | Column D Task Name | Column E Date/Time Stamp =IF($H$9>0,TEXT(NOW(),"mm/dd/yyyy - HH:mm"),"") | Column G Shows as: True /or/ False, Based on checkbox | Column H =IF(G9=TRUE,1,0) |
All of the checkboxes have been linked to the respective row for Column G.
Working on developing my Excel skill/knowledge, so this might not be the most efficient and/or effective method.
Thanks