-
Initial Setup Assistance: Hierarchy Req- Multiple Clients, Multi Projects, Multi Tasks
Before I get to it and go crazy generating all my works, can you please offer assistance in the best way to set up SS for my needs. Essentially, I want to be looking at one project at a time...my trials have left me with multiple tabs across various projects and clients, it gets confusing. If you are familiar with OneNote,…
-
See summarized duration/ % for header tasks
I have created a master sheet that links all my project gantt charts. Unfortunately I cannot see the summerized totals - is this available as an automatic function? I've been manually typing it in, but I'll have a lot of projects so this would be great if it was automated!
-
Production/Manufacturing/Importing
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?
-
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?
-
Travel approval workflow
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…
-
Summarizing Time sheet data
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.
-
Excel Export - Blank Cells No Longer Blank
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…
-
Contacts List
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…
-
Iterative process
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
-
Formatting With a Range of Dates
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…
