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 2015 Posts
Archives for June 2015
Discussion List
Formula to calculate week number or week commencing date
I have a column of dates in a smartsheet, and wish to insert a formula into another column what will tell me either the weeknumber (e.g. Excel WEEKNUM formula) or the weekcommencing date. Does anybody have any suggestions how to acheive this?
GPS
Does anyone know if there is a way to track an employee by GPS who is on the road that will populate into Smatsheets?
Automatic email after sending a form
Hello all Is there a way to send an email to a particular person after a user completed filling a form. I am trying to put in place a form for requesting extra hours and need to have a notification sent to me for validation
Dynamic Drop Down list
Hello! As you have already seen in forums, many customers demand drop down lists, that uses master column as the list entires. Whenever you add a new entry, the list in all other sheets updates with this new item. Do you have any other way to get this done, for example, external database linking or other solutions. We are…
Recurrent reminders
Why after i put the actual date on a task before the "planned date",it keeps sending me the reminder for this task although i already did it. Also ,why after pluging an"actual start date " it doesnt update the all other dates including the end date Thanks
Possible to hide weekends?
Is there a way to hide weekends (or any non-work days) so that they don't take up width in the Gantt chart view?
Critical Path
Does Smartsheet have the ability to calculate and show a gantt's critical path, like Microsoft Project's Critical Path Analysis (CPA)?
How do I append a text description to a formula
I have an fx: =“Task - “ + COUNT(children()) How do I append 'text' to this formula?
Drop Down Menu Questions
Hi there - We are using Web Forms for new product input from Outside Sales. Is there a way to have the forms emailed to a specific person if a specific category or a specific criteria is met? I have four Product Managers, all responsible for different types of products. In the Web Form, I have a drop down menu for the…
Multipal projects using one resource pool
We use MS Project to manage over 30 projects using one resouce pool. We also cross link certain tasks between these project. eg. Every project has Engineering yet we can not work on them all at once thus we link between projects to create a good view of their schedule. I am not finding where Smart Sheet can do this. Then…