-
Sheet Size
I have sheets that vary in size but most lean to the larger size due to the amount of formulas in the sheet. I am looking to see if on average people are choosing to have more sheets and less size or less sheets and fill the sheets to the top. I have done alot of work to all of my sheets and some have had to be divided. If…
-
Drop Down list in web form out of sequence
Good afternoon, I have searched the knowledge base to no avail, so... I created a simple web form with a drop down list containing 3 times: 9:00 am, 9:30 am, and 10:00 am. The column in the sheet with the drop down list is in order. However, when I created the form and previewed it the times were displayed in this order:…
-
Excluding indented rows from being auto-numbered
I am using a web form for users to intitate developent requests and have set up column to auto-number each job request (P0001, P0002 etc.). The shop supervisor then adds rows below each job request to assign tasks to different team members and indents these under the main job request. Smartsheet assigns each indented row…
-
Setting up alerts on a Report
We have a report that is populated when a cell is checked off from a tracking list. I would like to send an alert to co-worker when a new row is added to the report.
-
Changing the Fiscal Week from January to July (or any other month) does not affect the Timeline week
I am trying to view my Sheet in Gantt view, tracking top row by month and second row by week. This works fine, except my company's fiscal weeks are offset. I changed the settings modifying start of fiscal week to July, but the view on the Gantt didn't change. Same result using any of the other available months as start of…
-
Using a master list column and being able to link to other sheets
I have a question in regard to creating a dropdown list column. I want to be able to have a MASTER list that when I add a new item to the list that it will update to other sheets that contain the same list. Is this posible. I can see that I can copy and link rows to other sheets but it would appear that I cannot format a…
-
Conditional Formatting
I have a question that someone may be able to help me with. If I have a column called Finish Date. On line 5 - I enter a date that my customer wants project to be finished On line 4 - I have a automatic date that is from a predecesor based on finish date so that it populates automatically depending on the tasks completed…
-
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
