-
Pull Down Menu Options from Common Source/Sheet
All, I am using Smartsheets to track time, and have run into an issue that I have to believe there is a workaround for. We need our associates to track their time with specific job and client IDs. This can be done by making the time tracking entries show as a pull down menu of codes. But, when we get new jobs or clients,…
-
Can Smartsheet import live stock or historical currency exchange rates?
For expenses sheets it would be very useful to lookup fx rates based on the expense date for calculating local currency to reference currency amounts easily. Thanks
-
Day of the week formulas
How do I schedule repeating appointments on a specific day of the week; Ex: Every Mon at 10:00 First Tue of the Month at 09:00 I did not see the day of the week variable or formula. Thanks Alan Guggenheim
-
Reoccurring Reminders?
Is there a way to setup reoccuring reminders on task sheets. I have like 100 tasks on one sheet that happen over and over agian and it'd be nice to setup a reoccuring reminder that sends a person an email once every "days, weeks, months or calendar date" Etc. Anyone have a solution or workaround for this? Thanks!
-
Time Logger - Cell History
Is it possible to show time spent on a particular project? The data is already there within the cell history - it just need to be extracted somehow. The below data tells me the task has been "in progress" for 1 minute - 21.06 - 21.07
-
Make Stars yellow by Default
I am creating a New Hire Checklist and one of the columns is called required. If that row's task is required the start will be checked and show up yellow. How do I make all the starrs in the required colum yellow by default? So we have to uncheck only what isn't required instead of vice versa.
-
Repeatable Task
Hello, Is there anyone using a Smartsheet for employee leave or schedule tracking that has found a way to create a repeatable event such as a reoccurring schedule or leave (like telecommuting or alternate schedule). Thank you, Jay
-
Training Observation Form
I'm working with another department to create a trainer observation form in Smartsheet. The form is pretty long and has a lot of categories. When I started working with it the number of columns grew quite large. Does anyone have experience doing this in Smartsheet? Any tips? Thank you, A. Lopez
-
Tip for Day to get the team to play.
One of the things that we have done as of late to speed the ability to work in the sheet and for people to move about in the sheet is hyperlink your sub sheets to your master sheet. The Hyperlink creates a fast way to go to anothe sheet without closing the main sheet. If you have you settings correct you can have a new tab…
-
Enterprise Account Benefits
We have been living in the sheets for a couple years now and just signed up to the enterprise level. I have seen some questions and things in here that are wanting to know more. I wanted to say that at the Enterprise level the support is top notch and is motivating. When you are pushing yourself and the program it takes…