-
Asigning special dates in Time Line Display
What I try to make is: E.g.: There is a task for the time between Aug 5th 10 and Aug 18. On Sep 14 partner XY is required to be present in City AB. Is there a way to show the alert icon in Time Line Display linked to additional details? The notification is already possible and the message can be sent to appointed person.…
-
Can you schedule a report to run?
Hello, I just recently setup some sheets to help with payroll which tracks piece work (we're a manufacturing shop). They input the date they did the work and the number of pieces (I've built a sheet with every single part on it and put their respective price per part that calculates the total for that part). There is also…
-
How to send a notification to a selected recipient
How do I get SS to send a notification to a contact whose name has just been selected from the list and entered in a webform? Like, when column [supervisor] is set with a particular name, please notify [selected supervisor] of this change.
-
Conditional sharing of row data from one sheet to another
We have divisions that have an HR function. Each HR function has their own Smartsheet to monitor salary action data. Certain salary actions require approval from the Central Office. Is there a way to conditionally share specific rows from a Division Sheet onto a Central Office sheet? It seems the only way so far is if the…
-
Formula to block dates
I want to be able to not allow a training date to be entered, that is less than 5 days after the current day. If they try to enter let's say today's date, 7/31/15, it would not allow them. However if they enter a date that is 5 days or greater from today's date of 7/31/15 it would allow them to do so. In Excel I am able to…
-
Timesheets
Hi, To calculate the total cost of a project I need to be able to evaluate time taken against team resources and tasks then use that at a post project review. (Part of my ROI is undertsanding the cost of implementation) Can time be recorded against tasks or is there another way of doing something similar? Thanks Jason
-
Here is a Time Keeping Smartsheet
I have seen a few questions about time keeping in Smartsheets. I created a smartsheet for this exact purpose. We have been using this for almost a year now and it is working great. This sheet makes it easier for everyone in the office. The employees get a much faster response to their request, it has cut down on our paper…
-
Smart Sheet Real Time Timer
I am looking to see if a timer function can be added to log accumulated hours and minutes on a specific task your working on real time, for aiding invoicing, and/or assessing daily/weekly productivity over a range of tasks. Alternatively if a macro or VB script could be linked to a sheet for the same purpose?
-
Answered: How to offset a date picker
Hello SC, I have a staff request for leave smartsheet. I want to have the date picker 2 weeks forward, so that you cannot select a date within the immediately following 2 weeks. So, any date up to 2 weeks from now should be greyed out. Any ideas?
-
formula help with symbols added
I have used a google form for time worked and synced it with smartsheet. I then have a column on my sheet to work out how many hours have been worked on a particular day using the information supplied on the entry from the google form. For instance if Joe worked 09:00 to 17:00 and entered this on his google form submission…