When I discovered the SUMIFS statement recently it solved a problem that had made me keep things like the project timesheets for our company in a very rigid format that basically listed all projects and functions (types of work) that could be charged to. I had wanted to let people select the project they were working on…
Is there a template out ther somewhere to take all projects shared to an individual and create a weekly report (timecard) showing the number of hours that indiviual is scheduled to work on each project? It seems like most of this is available in Resource manager but I'd like to have it report hours versus % allocation.
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.
Is there anyway to stop updated cells being highlighted in pink for 1 hour after they have been updated? THe reason being is because whilst it is pink it is not possible to update the cell colour to anything else which is fustrating. woudl appreciate some help on this brook
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
I am looking to make a workflow for travel approval . As the request form should be accessible for all employees I would like to use a webform. Approval shall be done by the Project Manager if travel is project related or the respective Line Manager if it is for non project travel (training, conferences,...). The Project…
If I use a webform to collect time sheet data by employee by customer by task how can I then summarsie that data X date range X Employee x Customer x Task and visa versa.
I currently use Smartsheet for one purpose and still use Excel spreadsheets for another purpose. I have however hit a problem and wonder if anyone can help and provide a solution. Currently I have a sales spreadsheet for each employee. Each sheet contains a range of data. The range is the same on every spreadsheet and it…
I am trying to build a business case for my company to adopt Smartsheet, do you have something that could help me doing this? Like issues and how Smartsheet addresses them, how it can streamline busniness processes and projects. Benifits, uses, etc.. We are in Financial Services and Investments. We manage alot of projects…
Hello Everyone I am in the process of creating a budget sheet in smartsheet. I need to have a total monthly amounts transfer from google sheets to one cell in smartsheet. Also, when data is updated in google sheets also will update in smartsheets. Try to get a link for one cell but I can't find a way to do this. Any ideas?