Hello! Here is what I am trying to accomplish! In the column with the flags (highlighted yellow), I would like the flag to turn red when the Percent Complete Column (highlighted Green) is less than 10…
Hi, I recently realized that Smartsheet has a major flaw in rolling up % Completion. In Smartsheet %complete for a Parent is calculated as a weighted average of %completion of the immediate children t…
Trying to count the total number of "open" and "Waiting" issues in a another sheet =COUNTIF({Sheet - RAID Log Range 1} Status:Status, "Open")+COUNTIF (Status:Status, "Waiting") Hitting a wall, getting…
Hi there, can anyone help me on this formula ? it looks the only issue could be on the date format but I don't know what I have to change. =IF([Expected Order Date]4 < 3 / 31 / 18, "1Q 18"; IF([Expect…
Hi, are there plans to add the feature to edit/update rows and columns through web form? it would have save me a lot of time if I could do that. thanks.
Hi, I want to see my project team on the Dashboard (with the profile picture and designation). Can we add Smartsheet users dynamically to the dashboard? thanks
Hello, When I copy a graph on the dashboard it keeps the same formats (color scheme, grid lines, etc.), however when I change the data I want to look at it completely reverts back to defaults even if …
We have a project plan template and populate the 'assigned to' column with the role/title. Once I copy the new project plan template, how could I automatically update the 'assigned to' by task based o…
Hi all, I am struggling to find a solution for this. I have 15 individual sheets for a project. One of the activities on sheet 2 will include a "yes/no" question. If yes, then sheet 3 needs to be comp…
