Removing System Generated column (Date) contents

I have completed building and testing my sheet and Dashboards. I now want to remove the System Generated Date for all my Form entries used for testing. If I remove the column and reinsert it, the formulas dont work. Is there a simple way of removing the system generated date data?

Find more posts tagged with

Sheets

Formulas

Comments

Andrée Starå

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

wrightco12

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

Sys Gen.jpg

Andrée Starå

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

wrightco12

I created a template as you suggested and it worked like a charm. Thanks so much for your help!

Andrée Starå

Excellent!

Happy to help!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Calculating Quarters with a Start and a Finish date
I searched the community and did not see a formula that calculated Quarter based on a Start and a Finish date while also accounting for cases where the year for the Start and Finish date differ. The formula below handles that. A few notes … It assumes that Finish is always >= Start. The entire formula is wrapped with…
Circular Reference with formula
i am not good with writing formulas within a sheet. I asked the AI tool in the sheet to help me write a formula and I am getting a Circular reference back. I'm trying to have it write the following formula for me. If the column "Tracking #" is not blank, change Column "Deployment Phase" to "Shipped" I have tried adding in…
How to delay the execution of a workflow whose trigger occurred much earlier?
I have a workflow that detects a row(date) that is changing its Fiscal Week Finish Date and send this row to other Sheet. Long story short: I collect delayed tasks in separate file & I tag reasons for delay for these tasks. It happens that plan are analyzed 2-3 hours and dates are being changed several times. I would like…