-
edit rows and columns from web form
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.
-
Integrating User Profile into Dashboard
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
-
Cannot Copy Chart Formats with New Data
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 the data is the same # of cells and the same type of cells. Is there any way to keep the same formats but change the data…
-
Auto populate Assigned to based on reference
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 on a role/name mapping. Could I have a project resources sheet with role and name and have the Project Plan tasks 'assigned…
-
"If clause" in Dependancies
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 completed. If no, then sheet 3 will not be necessary. I can't see an efficient solution for this. Any suggestions? Thanks!
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
Smartsheets Project Management newbie
I am new to Smartsheets and new to project management. Is there a smart sheet course that I can take that caters to a project manager in training? The videos I am finding are not quite descriptive enough for me and are only about 5 minutes long. Thanks
-
RYG Status Formula
We have two set of data that are required. Count column that is 0 until there is entry into one or all of the previous columns. This formula provides a count (this formula works fine) =IF(Series5 = 0, IF(COUNTIF([SKU 1]5:[SKU 15]5, "") = 0, 1, 0), 1) In the RYG column I have this Formula. =IF(Count5 = 0, "Green", IF(Count5…
-
COUNTIF Function
I'm trying to count everything in a Type column that = "Risk" that match a status of "Red" and "Yellow". How would I add "Yellow" to this statement? =COUNTIFS(Type:Type, "Risk", Status:Status, "Red")
-
COUNTIF Function
Im trying to count 2 columns on a issue sheet and want to count out each specific type (Risk, Action, Issue, Decision) that are open (not counting the closed or in progress types) I have these formuals but its not producing a result * =COUNTIF(Type1:Type50, "Risk", [Status1]:[Status50], "Open") * =COUNTIF(Type1:Type50,…