Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2016 Posts
Archives for November 2016
Discussion List
feature
Hello - I would like to keep the start and end date of a project. Without having an attachemnt associated with the project, can I add people and their roles for this project, on the lines below the project, and then hide those lines? Thx.
Spred Sheet for each Department
Hi there Everyone I am new with smart sheet and i work on a Engineer firm. I am encharged of the design department and i was wandering if it would be wise to make a sheet ony to this department. Or making a sheet to work with all departments at the same time. If someone can help me with this! thanks!
Counting of hours
To All, I am trying to build the Smartsheet as a service schedule. One of the may problems i have right now is trying to add up hours that the technician has worked. Im looking to count the number of hours thats been assigned and providing how many hours to date (Just for the week) that has been worked by the employee
Alerts for Created (Date) Column
I can't seem to find a way to set an alert if the Created Date changes. This would essentially only alert me when a user filled out the web-form and not if someone changed the contents of the row. I have an employee that needs to know when a new row is added, but doesn't need add'l updates when other employees massage the…
Salesforce and Smartsheet Integration
Hi Everyone - Have any of you used the new Salesforce/Smartsheet integration with project plans? I see and understand how it can push and pull data as reports between the systems, but I need to figure out how to take a cell in Smartsheet (Due Date or Date Completed for instance) and map that specific cell to a specific…
Convert date format to mm/dd/yyyy
Is there a setting or a formula to convert the standard yy in smartsheet to yyyy?
Using Report builder to find past due 'Days' tasks
I have a sheet that lists bugs and it has a 'Created Date' column (not a system column, just a date column). I need to generate a report of all issues that are 'Open' and 30 days old. I can check for 'Open'. But I wasn't able to find a way to check for 30 days old in the report builder. Can I do this just using the report…
Other Sheets In Resource
In my Resource View following deleating a sheet now have "another sheet" which i cannot get rid of. This shows my resource 200% now Any thoughts?
Tracking a date change
I am new to Smartsheet in a company with limited knowledge about the features. We use a combination of sheets and a web form for 'ad-hoc' requests that are managed in a queue. In the queue, there is a "Due Date" column. This date can change over time and the manager for the area would love to be able to track that change…
I'm looking for a way to calculate time of day based on predecessors.
I have a very specific need to a time intensive schedule that requires time of day (TOD) to calculate based on predecessors. Currently I have been manually entering TOD of Start Time and Finish Time in general columns but would prefer these to be formula driven. Has anyone done this?
