Has anyone done a SS that incorporates a "form" of invoice entry (web part?), that after entering automatically logs to a SS tab, then can track budget vs. actual cost (and allow projections) for a project......MS Excel has a good template but without additional programming it only does one calendar year of…
I am looking to automatically populate a "STATUS" column with 1 of 5 values based on critera/conditions are outlined below. The key drivers here are the - [% Complete] - [Start] Date - [F/C Finish] Date - this is a column I have set up that uses a formula to predict a Forecast Finish ([F/C Finish] = (Today() + (R x D))…
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…
I have groups of tasks that ocurr in different projects and would like to copy rows that define those groups and insert them into other projects. When I copy them from one sheet to another, I lose the sequential dependencies between the copied rows. It takes time and and introduces errors to have to re type the…
Hi to everyone I would like share with others users my questions about peparing the sheet for organize the jobs of the company where I work to see what are you guys think about this subject. I have to organize and follow every job of the company. The company have a lot of jobs (many hundreds) and in each jobs have about 15…
One of the users of our sheet is randomly losing data he has entered, even after saving it. I went throught the steps given under the FAQ, and that has not helped. Also, his auto-save is set-up through his personal settings, and yet it is not auto-saving. Help!!
Can smartsheet have a template built and provided to our Clients from a web portal that they entered via user/pass. I know we can embed smartsheet. The situation is that I want each of them to have their own private sheet. Also, we want access, but is our CLIET's responsibilty to keep this up to date. In essence, we are…
Hi Community, I've got backups under control... BUT what I've found from various options / systems is that the reports can't be backed up. Has anyone found a way to do this?
We use an AIA form process for the pay applications in our industry. I am wondering if anyone else has been able to implement an AIA form in a sheet?
We have developed a master process sheet that starts when a client signs a design contract and is completed when the build project is completed. It is rather long at about 250 tasks! and take between 6-12 to complete. We serve approximately 20 clients at a time in various stages. We are operating each client out a copied…