Updatable fields in a report.
I have a report with several updatable fields. These are updatable in the underlying sheet. The problem is with date field. It won't allow me to update it in the report. All the other fields (4) work fine. 1 is a text, 1 is a contact list, 2 are checkboxes. Are date field not allowed to be updated in a report? If so, why not? Trying to get this to work with a dashboard so mangers can update the report without having to open the underlying sheet.
Comments
-
Hi Sharon,
Check the columns in the report. Have you changed the name or type?
Hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
It could also be a column used in dependencies that is making it so it can't be edited.
-
Yes, I am selecting on "Due Date is in the past" for the report. Guess that explains it. Wonder if there is a work-around somehow. It would be nice to have users just update their own date as needed. (Right now I have been making these changes. )
Thanks for your response. I appreciate it.
-
Thanks for responding to my request Andree.
I think my problem lies in my selection using the Due Date field. UGG!
-
Ok.
Happy to help!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Unfortunately the changes would have to be made manually and in the sheet itself because formulas aren't allowed in dependency columns yet.
I would suggest a Product Enhancement Request.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives