We started a new process for course development that has tracking development of each of our courses in separate sheets. 1 course per sheet. Its easy to pull a report of how many of those courses are …
I'm trying to find out if I can color code only the name bubble. For example, below I'm using the multiple-drop down column formatting and all names are shown in grey. It would be nice to show Whitney…
I am using this simple formula in a new field in Sheet Summary & I keep getting an "Unparseable" Error. =COUNTIF(RESPONSIBLE ENTITY:RESPONSIBLE ENTITY, "FIRM")
Hi community, I'm trying to count the tasks in my gannt per each week in a separate grid. Then i'll make a graph representing work overloads throughout the year. Here is my formula that calculate 0 ev…
I have a start date of 10-1-19 and a stop date of 10-31-19 and I want to see how many working days are in the range. I am using the formula as follows: =NETWORKDAYS([Schedule start]1, [Schedule stop]1…
Hi, I have a risk register for a project that has well over 100 risks documented and I have them categorized into 17 different risks. I would like to be able to create a formula to count how many risk…
Hello, We are currently managing a construction project with smartsheet and have created a Gantt Diagram and a few Dashboard to monitor several KPIs. The dashboards are updated automatically with ever…
How I can pull data from a cell with multiple values to create charts/graphs? Currently, the graph only shows/captures single value from the cell and not the other one. Is there a way around how to ge…
This is probably a very simple formula required but I am struggling with it. Can somebody please assist? We have a number of clients on one sheet where we track different trades budget vs. actual for …
I need to import an existing project plan (call it A) into an already project plan (call it B). A is under a different corporate account than B. I have access to both. I need to merge the 2 project pl…