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…
I am a new user to Smartsheet. Still testing it out for the 30-Day Trial. I really like Smartsheet, but am a bit concerned about becoming too involved with it because it does lack some functionality I was hoping for. That said, only a few of the upper end (expensive) project management programs seem to do what I want.…
I've been struggling all day with a complex sheet, discovering multiple times throughout the day that formula's appear to have been deleted. Before Filtering - every cell had a value, either 0.000 or greater; parent rows were totalling correctly. Action: Filter column 'Q1 Total' to show only those cells that had a value…
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?
Can you formulate status symbols to change based on % numbers in another cell?
I'd like to create a workflow which will collect data from a webform (can I edit the look & feel of the web form UI?) and have that data forwarded to several people for approval without the need to go to echosign. The webform is the easy part (thank you Smartsheet), but the rest of the approval confirmation on the sheet…
this would be helpful since I have some columns with long titles but the values are small numbers so the width of the column truncates the text... it'd be nice to be able to hover my cursor over the column header to see what it is.
i.e. exclude red from a SUM function, so all the red values are not added up
I know how to achieve this in excel but can't figure it out here. We are looking to highlight a cell (or row) if the number of business days between two cells is less than 3 business days For example in a row we have: Date1 = 11/30/15 Date2 = 12/2/15 In this case above we would want to color Date2 red (or the whole row)…
I have a Gantt Chart with dependencies enabled. When I shift the entire start date of the project all the dates shift appropriately so I believe it's working well. I've just inserted a new row and assigned a Predecessor Row and Duration. The bar appears to the right and dependency lines are drawn. However the Start and End…