How to auto populate time in a table on sharepoint (and can edit)

annonnon 101 Reputation points
2021-10-21T03:36:26.657+00:00

Hi,

I have a calculated column - Calculated (calculation based on other columns) - with the below formula inputted to auto-display the time:

=TEXT([Serial Start Date/Start Time],"hh:mm")

However, I noticed this makes the cells on Sharepoint 'read-only' - so I can't make edits to the time if I wanted to change something.

Is there a better formula to use where I could get the time to be auto-populated (based on a previous 'Date & Time' column), but still be able to make manual changes to contents in this cell? (without the time being altered from the original Date & Time Column which the information is being extrapolated from).

Thank you!
142568-image.png

142580-image.png

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,409 questions
0 comments No comments
{count} votes

Accepted answer
  1. Yi Lu_MSFT 17,446 Reputation points
    2021-10-22T09:40:59.407+00:00

    Hi @annonnon
    Per my research, the column with formula could not be edited manually. The value of it is depended on the calculated formula.

    For example, I set the "add" column formula as 1+2, then the value could only depend on column "1" and column "2", which is read only.

    142907-image.png


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


1 additional answer

Sort by: Most helpful
  1. Sonali Hanumant Satpute 101 Reputation points
    2021-10-21T03:42:40.073+00:00

    Go to List settings -> Advanced Settings and Select Allow management of content type then press Ok. , and click in the _hidden column. Set the column setting to Hidden and click Ok.