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

Question

question

annonnon-4680 asked Oct 21, '21 YiLu-MSFT commented Oct 25, '21

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

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!

office-sharepoint-online

image.png (4.9 KiB)

image.png (21.8 KiB)

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2021-10-22T09:40:59.407Z

YiLu-MSFT answered Oct 22, '21 YiLu-MSFT commented Oct 25, '21

Hi @annonnon-4680
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.

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.

image.png (4.9 KiB)

· 2

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

annonnon-4680 · Oct 24, 2021 at 09:26 PM

Hi @YiLu-MSFT,

Thank you for your response.
I see, so then there is no formula or method to have it auto populate the details but also be able to edit the cell?

0 ·

YiLu-MSFT annonnon-4680 · Oct 25, 2021 at 07:56 AM

Yes, this is by design.

1 ·

Answer 2 · 2021-10-21T03:42:40.073Z

SonaliHanumantSatpute-8215 answered Oct 21, '21 annonnon-4680 commented Oct 21, '21

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.

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

annonnon-4680 · Oct 21, 2021 at 04:59 AM

Hello,

Thank you so much for your reply.

I clicked allow management of content type but the cell remains 'read-only' :(

With the _hidden column, where would that be? Is that to hide the original Date & Time column which the calculated column is extrapolating information from?

0 ·

question