Is there any way of overlaying calendars from 2 different sheets? What I'm trying to do here is to create multiple sheets (1 for each project) with all the same tasks but with different start and end dates. I would like to be able to see on the gantt calendar if the same task is happening on multiple sheet at the same…
I just started using smartsheets for out development firm. we have hundreds of new consturction homes that we keep seperate data sheets on everything from bidding, to actual cost, to scheduling. I would like to be able to pull the data out of each sheet and generate a report that details how much I pay for each style of…
I often need to copy and paste from and to smart sheets, but find that it uses its own clipboard. Say I have a 9 digit number in an excel sheet, and I want to just bring the info from that one cell into my smart sheet, I will copy from excel, but when I paste in smart sheet, it pastes the last info I had copyied within…
I just started to use the mobile app in conjunction with the Reports and I am running into some functional issues. When I use Reports on my PC and want to go to a specific line from a report, all I have to do is click on the linked report. It takes me right to the line I was looking for. When I go into a report on the…
I have a combined report that is pulling information from 10 different smartsheets. The columnar information is the same from each of the smartsheets. I have it grouping by the smartsheet the information is coming from, but I would like the "title" of the smartsheet to show up at the beginning of the data from each sheet.…
Is there a way to configure Smartsheet to bring me back to the same location is was when I last logged out of the program?
I am trying to set up a sheet that tracks employee hours for the week and any overtime or stop out allowance, has anyone found the best way to do this? Ideally I'd like to use a web form so each employee can pick up the web form, enter their information and it be transferred to a sheet for payroll. Many thanks
Is it possible to produce a Gantt Chart with costs? ie as you add Parents & Children the Parents Costs row will total the Children Costs row Have tried various formulae but other than building the full Schedule then adding formulae to each Parent row it seems to be a long winded method of populating the costs. Can anybody…
I'm trying to print the schedule without the gant chart. Just the items and date of start and finished.
I have a main sheet with many reports pulling from it. All was fine until about an hour ago. No matter what I do I can not get the reports to update. All the criteria is correct. Help....