Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
Sheet changing entries
This sheet is created to track expense reports, and the users enter "Project abbreviations" via form, the form is then mapped onto an expense report PDF. The initial entry everything is done as it is supposed to. However, for an unknown reason/cause the project abbreviation entry is changed to a random abbreviation that was not initially entered. This happens randomly so it is hard to say what is triggering it, there are no other users that actively work on this sheet but me, so I know it is not another user causing the issue.
Answers
-
Hi @Rashelle JM this sounds like a unique situation. Can you give us an example so we can better understand the question and help you?
Thanks,
Ipshita
Ipshita Mukherjee
-
This is the sheet, and lines are added by an automation form that is submitted. It is then set to be mapped when a new entry is added to an expense report PDF.
This mapping reflects the project abbreviation that was initially entered, and I circled what would be entered as "8. Project Abbreviation" on the sheet. On the sheet, you can see that the entry is different and listed as "EAS000" when it was originally entered as the "GALK02, GCHU02…etc" & I do check when the entry is entered so it was previously accurate, but something causes the sheet to automatically change on this and the other "1-9. Project abbreviation" columns that are on the sheet.
There are 9 project abbreviation columns that are list each named "1. Project abbreviation" and so on —
here is what the column type is and reflects the same on all of the columns, the values are a part of a data shuttle from another sheet.
-
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67K Get Help
- 441 Global Discussions
- 154 Industry Talk
- 502 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 79 Community Job Board
- 512 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Hi, I have a sheet where the user enters a code which then brings back metadata from other sheets. I would like to have this field on a dashboard so the end user doesn't have to navigate to the sheet …
- On my form- Field question "Attention Needed" has 3 options, "OK", "NEEDS ATTN", or "Out of service". I have twelve subsequent fields that have options either "OK" or "NEEDS ATTN". I am having a probl…
- Hi, I converted a word document into a fillable PDF. I set up all the text fields in the PDF so that Scroll Long Text and Multi Line are checked in the properties options. When I type a long paragraph…
