Can a (date) cell be locked once data gets entered thru a Dynamic View???
I have been browsing around both the active and archived threads but have not been able to find information even similar to what l'm looking to do: I am trying to have a field (Estimated Start Date) to get locked and show as read-only in a Dynamic View once a date it's entered in the corresponding field by the contractor via a Dynamic View.
Currently l have the Project Settings setup to have the Must Finish by Date show as read-only in the Dynamic View as it will be manually entered in the sheet.
is it possible? I know both the column and the row can be locked but that's not what l need. I also looked into doing it using a field logic in the DV but the specific field was not available so l am running out of ideas ☺
Help Article Resources
Check out the Formula Handbook template!