i have a date field that won't is not editable in dynamic view and it is not a calculated field. Any thoughts?
This is the information from the Help Center article on Dymamic View (see here):
Some fields may not be editable depending on their data type or the information in the cell. The following conditions make a field read-only in Dynamic View:
Check to see if your date field matches any of the above criteria.
In regards to your fields not showing up as "filter" fields, do you mean in the View Filter section? If so, columns able to be selected would need to be a Drop-Down type of column or a Symbol column. In order to create a filter using a dropdown list or symbol, the field must be a Visible field. (see here)
If this does not explain the behaviour you're experiencing, it might be helpful to see screen captures of your underlying sheet and also how you are configuring it in Dynamic View.
Several fields from my sheet are not showing up as filter fields. Is there some field type that are not available?
Genevieve, Thanks so much for the information, it was very helpful.
@Genevieve P Piggy back riding on this question ☺
I have a similar situation, end date field in the DV is showing as read-only, and l am trying to pinpoint it to the Project Settings, as the field was working fine before the setup was modified (this is a shared sheet and this setting update was done to collect metrics) this is what the column setting looks like (same for Start and Finish Date):
Thanks for the details! I appreciate it.
Yes, you are correct! The reason your "Onboarding (Internal Finish Date)" cell is greyed out in Dynamic View is because its the "Field is from a Gantt End Date Column" from the options listed above.
You can see this in your first screen capture: under the "Date Range Display" heading, this same column is selected for the "End Date Column".
Thanks @Genevieve P!
Hello. I have the same issue. How do I fix this so the greyed out field is editable in the Dynamic view?
It will depend on what field it is that's greyed out... which one of the criteria below does it meet?
Field is from a System Column
Field is from a Gantt End Date Column
Field is from a Gantt Predecessor Column
Cell in source sheet contains a formula
Cell in source sheet contains an inbound cell-link
Cell in source sheet contains a Hyperlink
It's likely that you'll want to create a new column to gather the different data via Dynamic view, instead of changing the current column in the sheet. You can read more in our Help Center: https://help.smartsheet.com/articles/2478391
I have a dynamic view where I've a check box with the initial value 'checked' but as you can see in the second screenshot below, it is not checked for some reason. Is this a known issue, or am I overlooking something?
I need to apply a dynamic filter criterion to a date field, specifically filtering for rows where the transaction date is current day, within a data shuttle workflow. Unfortunately, I can only find static date choices, which is inconsistent from what's possible in Smartsheet reports (where I can use the "is today" filter).…
Hi, We are using WorkApps more and more to create a "one-stop shop" where users can go to access forms, sheets, reports, dashboards & dynamic views. Some users have admin access to sheets, and we lock certain columns to ensure that editors can only amend specific information. However, when sheet admins use WorkApps then…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.