question

annonnon-4680 avatar image
0 Votes"
annonnon-4680 asked YiLu-MSFT commented

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!
142568-image.png


142580-image.png


office-sharepoint-online
image.png (4.9 KiB)
image.png (21.8 KiB)
5 |1600 characters needed characters left characters exceeded

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

YiLu-MSFT avatar image
0 Votes"
YiLu-MSFT answered YiLu-MSFT commented

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.

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.



image.png (4.9 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

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

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 Votes 0 ·

Yes, this is by design.

1 Vote 1 ·
SonaliHanumantSatpute-8215 avatar image
0 Votes"
SonaliHanumantSatpute-8215 answered annonnon-4680 commented

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

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

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 Votes 0 ·