-
COUNTIF in Sheet Summary
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")
-
count tasks per week number
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 every time (at least not an error) : =COUNTIF({6530 - Sulfuric project Schedule Range 5}, WEEKNUMBER({6530 - Sulfuric project…
-
Subtracting dates
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,) I keep getting #UNPARSEABLE Must be doing something wrong? Regards, ds
-
Create formula to count category risk with aggregate rating
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 risks exist under each category and then a formula to show the aggregate risk associated with this. I would think by a…
-
Cell values export from one project to another
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 every changes in the master project and provide up-to-date information during meeting. I would like to add curves to the…
-
How to add multiple values when creating a chart/graph?
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 get this done? For example, when i am trying to build a bar graph for the values under "Hiring Manager" on row 5 -the second…
-
Rollup summary of data
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 each client. e.g. Plumbing, Electrical, Carpentry etc. We want to count up all the budgets for the Plumbing for all clients…
-
How to import/merge 2 Smartsheet projects plan into 1?
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 plans into 1. The question probably has been asked but I can't find a "real" answer. Thanks for your help!
-
Locking or freezing the TODAY() formula
Good day all, I've looked around in the community about locking or freezing a current date, but I'm still having issues. My goal is to lock a start date that's triggered by entering a X and have that current date freeze until the x is removed. When an X is entered in the Visit column, that triggers a start date to…
-
Check a task done from a report on a dashboard
It could be I misremembering --- I have a report that lists all the users tasks and the tasks are accompanied by a Done checkbox. Is there a way to allow users to check that box _from the widget on the dashboard_ rather than having to open the report or the source sheet. Is this possible or a fever dream?
