强啡肽mic View: Un-editable Fields

迈克尔Wilkesen
迈克尔Wilkesen ✭✭✭✭
edited 06/14/22 inAdd Ons and Integrations

I am having an issue with Dynamic View treating (random) editable fields as "Read Only."

In this instance, Dynamic View is treating a Date Field as if it were a "Read Only."

In the first screen shot, you will see that the "Date Resolved" field is not marked as "Read Only" in the design mode, however, when you open the View Details, the "Date Resolved" field is treated as if it were "Read-Only."

I have verified that the Source Sheet column is not "locked" and does not contain a formula, and is "checked" as "Date Only" (screenshot 3). I have also validated that both the "Date Resolved" and the "SCC Initiated Date," also shown in screenshot 1, are set up identically in the Source Sheet.

Historically, when an issue like this occurs, I would simple delete the column from the Source Sheet, and begin again, however, I have a number reports that are built off of this sheet, and if I were to delete and re-build, I would need to update all the reports, and I would like to avoid that if at all possible.

Any advice/feedback would be greatly appreciated.

Annotation 2021-01-04 01.jpg
Annotation 2021-01-04 02.jpg


Tags:
· Share on Facebook Share on Twitter
«1

Answers

  • 迈克尔Wilkesen
    迈克尔Wilkesen ✭✭✭✭
    Annotation 2021-01-04 03.jpg

    I failed to upload screenshot 3, and could not edit my thread, so here it is.

    · Share on Facebook Share on Twitter
  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi@Michael Wilkesen

    Are you using dependencies and is the Date Resolved part of it?

    I hope that helps!

    Have a fantastic day & Happy New Year!

    Best,

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    ✅Did my post(s) help or answer your question or solve your problem? Please help the Community bymarking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    https://workbold.com/

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

    · Share on Facebook Share on Twitter
  • 迈克尔Wilkesen
    迈克尔Wilkesen ✭✭✭✭

    Thanks Andree for reaching out; dependencies are disabled on this sheet.

    · Share on Facebook Share on Twitter
  • pe22
    pe22 ✭

    I am having the same issue and it's driving me nuts. I checked all the other forums but unable to find a solution that works.

    · Share on Facebook Share on Twitter
  • Mel.
    Mel. ✭✭

    I am having the same problem. There are 3 different date columns, and only one is not allowing edits. We made a copy of everything so we could tinker without breaking our co-worker's actual sheet or messing with the data, and guess what? All worked on the copied version. We cannot for the lives of us figure out what the problem is in the original sheet.

    · Share on Facebook Share on Twitter
  • Genevieve P.
    Genevieve P. Employee Admin

    Hi@Mel.

    The following conditions make a field read-only in Dynamic View... could your date column be one of these in the source sheet but not the copied sheet?

    • Field is from a System Column
    • Field is from a Gantt End Date Column
    • Field is the "End date column" in the date range display of the project settings
    • 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

    (These details are pulled from this Help Article:强啡肽mic View App: Create and Administrate Views)

    Cheers,

    Genevieve

    · Share on Facebook Share on Twitter
  • Leslie Ambs
    Leslie Ambs ✭✭✭

    I am having the same issue. I have 3 date fields, only one is grayed out and not editable in DV. The field does not fit any of the criteria listed by the admin in this thread. The settings for this field are identical to the other 2 fields that are editable. There is no difference noted in these fields.

    Please help!

    Leslie

    · Share on Facebook Share on Twitter
  • Genevieve P.
    Genevieve P. Employee Admin

    Hi@Leslie Ambs

    Would you be able to post screen captures of your Dynamic View, then underlying sheet, and the Column Properties for this one date column? (Please block out any sensitive data).

    Thanks,

    Genevieve

    · Share on Facebook Share on Twitter
  • Leslie Ambs
    Leslie Ambs ✭✭✭

    @Genevieve P

    See attached

    Sheet View.jpg
    强啡肽mic View.jpg
    DV Setting.jpg


    · Share on Facebook Share on Twitter
  • Genevieve P.
    Genevieve P. Employee Admin

    Hi@Leslie Ambs

    Everything looks good from these images, which makes me believe it's possible this date column is selected as the "End Date" in your Project Settings for a Gantt Chart.

    Can you right-click on the column and instead of going to Column Properties, go toProject Settings? If this column is selected as the "End Date", that's why it's currently greyed out.

    Screen Shot 2021-05-26 at 3.53.30 PM.png

    Select a different column as your End Date and then you should be able to edit this one from the Dynamic View!

    Let me know if this was the issue.

    Cheers,

    Genevieve

    · Share on Facebook Share on Twitter
  • Leslie Ambs
    Leslie Ambs ✭✭✭

    thank you@Genevieve P, that was it! This is not set up as a "project" so I did not know that it has a default end date. We created a dummy date column to point to in project settings and all is working now!

    good to know!

    · Share on Facebook Share on Twitter
  • brhea110891
    brhea110891 ✭✭✭✭

    I am experiencing the same issue as above and tried to change the end date, but am unable. It is a little odd.

    In the DV, I want toe 2024 Summer PL Start and Finish Dates to be editable, but can't deselect Read-Only.

    In the Project Settings the 2023 Start and Finish Dates are the only options.

    Not sure what to try next.

    Thank you.

    image.png
    image.png


    · Share on Facebook Share on Twitter
  • Genevieve P.
    Genevieve P. Employee Admin

    Hi@brhea110891

    Do you have a formula in that column at all? Can you show a screen capture of how that date column is set up in your source sheet, but blocking sensitive data.

    · Share on Facebook Share on Twitter
  • brhea110891
    brhea110891 ✭✭✭✭

    Hi Genevieve -

    Thank you for your help.

    Yes there is a formula: =[2023 SI Start]@row + 365

    Is there a way to remove the formula and keep the date determined? This is a huge sheet with over 400 rows.

    And I have 37 Dynamic views for each Work-Area.

    What are my options?

    Becky

    · Share on Facebook Share on Twitter
  • brhea110891
    brhea110891 ✭✭✭✭

    Building on my above question - Is there a way to copy dates without the formula to another column, but not one-by one ... I have 400 rows with dates?

    · Share on Facebook Share on Twitter

Categories

Hi @Matthew Drake<\/a> <\/p>

There currently isn't a way to overlay an Outlook Calendar on top of a Smartsheet Calendar; you can do the reverse, publish dates from Smartsheet into Outlook.<\/a><\/p>

Please provide your feedback to the Product team through this form, here.<\/a><\/p>

Thanks,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":91824,"type":"question","name":"Dynamic View - Dropdown Lists","excerpt":"I have certain single and multiple select list columns that do not have the \"restrict to dropdown values only\" checked on the source sheet but in Dynamic View we are unable to add in our own values if they don't exist in the dropdown. This has been extremely frustrating especially when trying to capture new values and…","snippet":"I have certain single and multiple select list columns that do not have the \"restrict to dropdown values only\" checked on the source sheet but in Dynamic View we are unable to add…","categoryID":343,"dateInserted":"2022-06-06T17:24:20+00:00","dateUpdated":"2022-06-14T14:39:36+00:00","dateLastComment":"2023-08-25T19:03:11+00:00","insertUserID":113932,"insertUser":{"userID":113932,"name":"Emmy Anderson","url":"https:\/\/community.smartsheet.com\/profile\/Emmy%20Anderson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jplUI_CI3bw!8o9VN1d3-no!6TkM7ozjpN6","dateLastActive":"2023-05-04T14:55:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":91566,"lastUserID":156788,"lastUser":{"userID":156788,"name":"Chris Broughton","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20Broughton","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!p0HeqRqVoXw!8_nRN9ijwLw!lUie_n6pld_","dateLastActive":"2023-08-25T18:59:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":566,"score":null,"hot":3347530651,"url":"https:\/\/community.smartsheet.com\/discussion\/91824\/dynamic-view-dropdown-lists","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/91824\/dynamic-view-dropdown-lists","format":"Rich","tagIDs":[319],"lastPost":{"discussionID":91824,"commentID":392652,"name":"Re: Dynamic View - Dropdown Lists","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392652#Comment_392652","dateInserted":"2023-08-25T19:03:11+00:00","insertUserID":156788,"insertUser":{"userID":156788,"name":"Chris Broughton","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20Broughton","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!p0HeqRqVoXw!8_nRN9ijwLw!lUie_n6pld_","dateLastActive":"2023-08-25T18:59:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-06-08T12:36:40+00:00","dateAnswered":"2022-06-06T18:38:56+00:00","acceptedAnswers":[{"commentID":332119,"body":"

Hi @Emmy Anderson<\/a> <\/p>

You are not missing anything. This is how DV works with dropdowns unfortunately. My work around in the past is to create an other option in the drop down, user chooses save. Then have logic built for a text field that appears so the user can input the values not present in dropdown. <\/p>

Hope this helps<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":319,"urlcode":"functionality","name":"functionality"}]},{"discussionID":66594,"type":"question","name":"Is there a way to use OR in a Dynamic View filter condition?","excerpt":"In a View, I can create a custom filter that selects where the Project Lead is \"Mike\" but I want to also say \"OR Debbie.\" Is that possible? It looks like I can only choose AND.","snippet":"In a View, I can create a custom filter that selects where the Project Lead is \"Mike\" but I want to also say \"OR Debbie.\" Is that possible? It looks like I can only choose AND.","categoryID":343,"dateInserted":"2020-03-09T22:27:57+00:00","dateUpdated":"2022-06-14T14:36:49+00:00","dateLastComment":"2023-08-23T08:56:50+00:00","insertUserID":34501,"insertUser":{"userID":34501,"name":"MikeChambers","url":"https:\/\/community.smartsheet.com\/profile\/MikeChambers","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/CT5AV825MQ3E\/nG12D47VYRO8A.jpg","dateLastActive":"2023-03-05T01:19:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T00:32:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":436,"score":null,"hot":3276579287,"url":"https:\/\/community.smartsheet.com\/discussion\/66594\/is-there-a-way-to-use-or-in-a-dynamic-view-filter-condition","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/66594\/is-there-a-way-to-use-or-in-a-dynamic-view-filter-condition","format":"rich","lastPost":{"discussionID":66594,"commentID":392055,"name":"Re: Is there a way to use OR in a Dynamic View filter condition?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392055#Comment_392055","dateInserted":"2023-08-23T08:56:50+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T00:32:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/814\/KBHVAAPJ5RYA.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"OR.jpg"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-03-12T17:06:46+00:00","dateAnswered":"2020-03-12T13:01:18+00:00","acceptedAnswers":[{"commentID":242817,"body":"

You are more than welcome!<\/p>

Glad to hear that it worked for your present use-case. <\/p>

✅Remember! <\/strong>Did my post help or answer your question or solve your problem? Please help the Community by <\/em>marking it as the accepted answer\/helpful<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=343&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-dateLastComment&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":643,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts

  • Outlook Calendar events populating Smartsheet?

    Good morning, I have attempted to search the answer but not having much luck. My question is: The team I am apart of currently use Outlook calendars to record the various event sessions taking place throughout the day in different rooms. We have begun using Smartsheet to record the events so we can display the statistical…

  • 强啡肽mic View - Dropdown Lists

    I have certain single and multiple select list columns that do not have the "restrict to dropdown values only" checked on the source sheet but in Dynamic View we are unable to add in our own values if they don't exist in the dropdown. This has been extremely frustrating especially when trying to capture new values and…

  • Is there a way to use OR in a Dynamic View filter condition?

    In a View, I can create a custom filter that selects where the Project Lead is "Mike" but I want to also say "OR Debbie." Is that possible? It looks like I can only choose AND.

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video