-
How can I put a drop down menu that dynamically updates or adds another field?
How can I put a drop down menu that dynamically updates or adds another field? I am a Project Manager. In my Web Form I created a Project Name field that has a drop down list of current projects to choose from. After I select a project, I want another field to appear underneath it to give the end user another option to…
-
Setting date ranges with start-date to start-date and end-date to end-date dependencies
I have a project where I am setting a range of production dates and want the sheet to auto-update if I update that there is slippage in the timeline to see how far out things push. It is easy to schedule dependencies on the front end. For example - if I have items: 1. PO to readiness of raw materials is 2 weeks from the PO…
-
User form- input with dependents?
Hello, I have a project template that I would ilke to use to put a project on a master schedule. I would like to fill in this template with a form, while it adds the item to a master schedule. Can I create a form that has rows with children dependents? Thanks, Harrison
-
Resource Planning/utilization
Hello, My client is implementing SmartSheet for their custom job shop. I want to induce a capacity model so they can better plan their workloads. Once all resources are set up in SmartSheet, how do I report their weekly utilization/planned utilization? Thanks, Harrison
-
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?
-
Resources and Events
I have a sheet that I use for managing corporate events. Has anyone has figured out how to use it to track non-human resources to avoid scheduling conflicts? For example trade show displays, vehicles, A/V equipment.
-
Enhancement Request: Choosing which task to display on Agenda
Hi, A great way to improve your existing features regarding Sync with Google Agenda (or even the regular Agenda view) would be to allow the user to check or uncheck the tasks he wants to be synced, and the ones he doesn't. I use a lot of titles or categories for my tasks and subtasks but most of the time they are…
-
Update Request single use link
Does anyone know if there is a way to allow a recipient of a "Send update request" to use the same link more htan once to update a particular row? An installation within my organization is a single day event but can span the entire day. I may need multiple check-ins from my field tech. Today, I send an update request to my…
-
Smartsheet MRP/ERP
Hi all, Has anyone used Smartsheet in the capacity of a simple MRP or inventory management system? If so, it would be great if some examples could be shared. Especially where teams have used the Smartsheet and Google Apps integration to serve as a dynamic ERP/MRP system? I've read a couple of articles describing this being…
-
Integrate with Team Foundation Server
I use a Sheet to track features that are listed in our Team Foundation Server. I am constantly trying to keep the features on my sheet sychronized with the entries into TFS. Is there anyway to communicatie to TFS so that I can always be in synch?