Hi we do alot of importing of containers and production/manufcaturing jobs is there a smartsheet that we could use to have all container imports in one place? what would the best template be to use? It would be easy to use one sheet for each but we really want to have it all in one place if possible?
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?
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.
The recent release has caused an issue with export to Excel. Any empty cell in the Smartsheet isn't actually empty when exported to Excel - I've got a tracking spreadsheet which uses as part of a calculation a count of non-blank cells in a column and this has stopped working. The last Smartsheet export I took on 7th July…
We have five licensed users from three very different departments on our account. Is there a way for each of us to have our own contacts list? Currently, it pulls any/all email addresses and it would be helpful if we could each create our own. Also, is there a way to combine the "My Smartsheet Contacts" list with the ones…
Hi has anyone figured out how to perform an iterative process in smartsheet? I am trying to manage a construction budget through smart sheet and need to be able to use several iterative processes to get the correct total contract dollar amount. Thanks Doug
I need to create a formula that looks at two different date fields and produces the result as a check (or no check) in a checkbox field. The two columns are: "Date Requested" and "Date Received." The expectation is that the "Date Received" will be 4-6 weeks after the "Date Requested." So basically, I need the box checked…
So i have been tasked with learning the In's and Out's of smartsheet and to find the best way to utilize all of its tools for our company. we currently do the majority of our work through GP which as an accounting program is great but doesnt have the best project managment capabilities. my Question is what would be the…
I'm new to Smartsheet and am considering in switching from MS Project to Smartsheet but there seem to be limitations: 1) Progress Lines - either I can't find it or there's no on/off for progress lines. it's quite messy when you have 1000s of entries. 2) Views - can't customize views based on users and audiences 3) Duration…
