Removing System Generated column (Date) contents
Comments
-
Hi,
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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.
-
Sure, I have created a sheet that complies the data from survey Forms. I submitted many forms for testing and now the sheet is ready to go. But since I have submitted so many forms for testing, I have dozens of entries for the System Generated Date. I do need the creation date but want the date to start when the my customer starts to us the survey tool, not to include the dates I used for testing. Now I want to remove all the testing data, including the creation date. Is there a way to remove that column of data without messing up my formulas. I am new to smartsheets so let me know if there might be a better way. If I delete the column, and add it back in, the formulas are all wacked. Any guidance would be appreciated. Thanks
-
Happy to help!
You're getting that error because the reference to the formulas was removed.
My recommendation would be to delete all rows except the first one (depending on your sheet structure) and then copy the first row and paste as a new row and then delete the first one. You'll have one created date on the first one. Another option could be to create a template instead, and then the date would be from when the template is created.
Would any of those options work?
Best,
Andrée
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.
-
I created a template as you suggested and it worked like a charm. Thanks so much for your help!
-
Excellent!
Happy to help!
Best,
Andrée
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!