Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Excel template that generates (automatically) formulas for smartsheet

Alvaro Paniagua S.

Alvaro Paniagua S. ✭

03/08/16 edited 12/09/19 in Archived 2016 Posts

Hi Guys,

I made an excel (macro enabled) that allows to my team create projects easily and faster. The file generates (automatically) formulas for smartsheet.

I publish the example here

You can register time here

This is the video

The video is in spanish, I will translate it in the coming days.

Regards,

Álvaro

Tags:

0 ·

Comments

JohnHinkle ✭✭✭✭✭✭

03/09/16

Neat! Looking forward to the english video

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Action item Tracker with 2 way sync for selective items
I would like to manager a Master Action Item Tracker, but there are some items on the list that are confidential. Is there a way for me to create a duplicate of that action tracker for selective rows and for my team and I to colloborate on updating status between the Master and duplicate tracker and have the updates feed…
Need help with a cross-sheet reference formula.
I am trying to create a cross-sheet formula so I can count the number of projects for a specific PM where the show start data is in the month of January and year is 2024. The source sheet contains show start dates that are in 2025 so I want to be able to avoid counting them by mistake. I'm basically trying to count the…
Auto Number Formula Help - Add Project Code as Prefix
Hello, Is there a way to create an auto-number system to show [Project Code]-P-[AutoNum] where the auto number references the project code in the same row? Here's an example to illustrate: But when I try to add this prefix system to the Auto Number column properties… [Project Code]-P- types it literally… "[Project…