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.
Storing formulas
If you have favourite formulas that you will use on multiple sheets can they be stored as template formulas or do you have to copy from a sheet each time you want to use the formula?
Comments
-
Hi Simon
you can do both of these and we call our favorite formulas Awesome formulas.
The other thing you may already know, but if when you have a full workflow of sheets and reports in a Folder with lots of Cell Linking and interaction, if you "Save as New" from a prepared "Empty one" but which would include Formulas, you can speed things up no end in setting up similar workflows. Apologies if you knew all that already.
Hope that helps
RichardR
ps we are in the UK to if you wanted to discuss?
-
Many thanks Richard. How do you save/store an 'Awesome' formula?
Simon
-
Simon
let me have your email address and I will share it with you.
Regards
RichardR@smarterbusinessproceses.com
-
Thanks Richard. You can reach me at shanlon@ocrf.co.uk.
Regards
Simon
-
Hi Simon
Simon I am sharing the sheet with you now.
If you could save as New so you have your own copy and remove yourself from sharing that works for me.
Regards
Richard Rymill
01937 541 553 if you ever need to talk, we are in Leeds.
