Welcome!

Update Smartsheet

Hi everyone,

My company just finished our event in 2017, and I want to take the same exact smartsheet from last year and use it for 2018.

Is there a way to take all my past bullets, and change the dates to 2018 without changing them all manually?

Thanks for any help with this!

Ctrl + F should give you a "Find & Replace" option. Give that a try.

M Fox,

I doubt you still need an answer to this, but for next year:

Ctrl+F can be used, but you need to search for /17 and replace with /18 but you may also change the 17th of the month to the 18th.

The safest way is to create a new Date type column and add this formula:

=DATE1 + 365

Where DATE is the name of your column with the date in it. That works because we know that this year and next year are not leap years.

Copy the formula to the rest of the column and then copy/paste-special (Values) back to the original column.

Craig

Dynamic View Editing Role
Hi all, I want to utilize the Smartsheet Dynamic View. Considering the "editor access" type in smart sheet I wonder if the users are aimed to edit the view, should have the editor role? If I am not shared the file with them, will they stay as a Smartsheet user with viewer settings but are able to view the file? Thank you!
Cannot create new Chart from a report
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
Limiting Access to Folder and it's assets
I shared access to a user to a specific folder under workspace A (folder is 2025-09-Service Factory). However, I can see that he's shown to have access to all the other child folders under 02-ACTIVE Initiatives. Why is that when I only shared out one folder? Is there a way to only share access to users to ONLY specific…