-
Dashboard Template Chart Works - Mine Doesn't with Same Config
I found a dashboard chart on a SmartSheet template that I'm trying to duplicate. I've verified the data in the chart is the same between "My Chart" and the "Template Chart". I've verified the chart config is the same. What the chart shows is different and doesn't seem to reflect my data accurately. What am I missing?
-
Formulas and Calculations
O.K. I have now inserted my formula to calculate a number of miles driven for a given trip. But now I want to copy the formula to the entire column. Right now the formula is just in row 1 of my SS and I know that I can grab the corner of row 1 and drag it down to copy the formula into the other rows but it puts a zero in…
-
Formulas and Calculations
I know this is a simple formula in SS and Excel but I am having trouble writing it. In one of my SS's I want to Insert a "Beginning Miles" and then insert an "Ending Miles" column and then finally a "Total Miles Driven" column. To me that formula would need to calculated the sum of two entries and then yield a result of…
-
Dashboard
I am trying to create a widget on Dashboard for project progression that includes factors such as "Total development cost to date" "Total development cost this calendar year" "Future spending in next 1,2,3, months". How do I program the cells in sheets to reflect these dates (ie. todays date plus 20 days for next months…
-
applying vacation or unavailable time to resources
Hello, I am an MS project user and in that program you could denote unavailable time for resources so when a task assigned to that person fell on an unavailable time period, the start and end dates accomodated for that automatically. Is there a way to do that in SS? thank you, Karen
-
IF statement with flag symbol
Per the attached screen shot. How would the formula be written so that the row2 flag turns red IF any of the flags(row3-row11) are toggled to red? Thanks
-
Working Days Counter Based on State, Lock # when completed
I am trying to create a counter that counts the number of days in work of a task, the counter only counts the days in work when the Scrum state of the task changes to sprint . I want the counter to stop counting when the state changes to done and lock that number of days in work (days in work from sprint to done) and still…
-
Automating RYG balls based on several columns
I am trying to automate the RYG ball status column, based on several factors. Red - if not marked 100% complete in the [% Complete] column after the [End Date] or; - if less than 7 days before [Start Date] and [RS] and [WOA] are not both =1 Yellow - If greater than 7 days before [Start Date], [RS] and [WOA] are not both =1…
-
Please help with formatting issue regarding C&P from external documents
Previously, I've been able to C&P multiple sections from an external document, and Smartsheet would automatically separate each section into separate rows in a selected column correctly. Now, the functionality doesn't work. What settings, or formatting, has changed? How do I get this to work correctly again? It's a HUGE…
-
Select multiples in either a drop down or check box on a form?
I am working on a customer survey (form) and would like the customer to be able select multiple items in a drop down or have multiple check boxes available in a single column? Is this possible now? Is this in development? I know there a couple of ways to work around this but nothing very elegant comes to mind. It's…