Sign in to join the conversation:
How can I lock details in the calendar app, so users can't change the data but only view it?
Thanks!!
Hi Lisi,
If sharing is turned on and if the person viewing the calendar isn't shared to the sheet, the calendar would be view only.
However, if they are shared to the sheet with at least Editor permission, they'll be able to edit row data from the calendar —except in locked rows or columns.
Changing their sheet sharing permissions to viewer would also prevent them from editing row data.
If you would like to set read only fields from within the Calendar app, I'd suggest submitting a Product Enhancement Request to let our Product team know that you'd like to have this functionality in Smartsheet as it's not currently possible.
Has anyone figured out a way to use a column as a created date but not have the time stamp? It causes problems for my manager trying to use that date to pull into PBI. I know how to convert in a helper column to a year-month and a year, but those have to be text/number columns, not date columns and he can't use those…
I am looking for a way to automate a cell so that when column A displays 9 'Days Open' (or between the values 0-14) the 'Req Age' will auto populate (or trigger) the ranges provided. Image below: I want the highlighted section to auto populate based on the value in 'Days Open'
Good morning, I haven't needed to do this is quit a while but I went to clean up the "Sheets" folder in my account and can no longer create a folder, sheet, or report in any area of that folder. The "Create" button at the top right takes me the templates page. This is what I am seeing vs what I can do within a workspace.…
