I want the formula to count how many risks there are that are open. =COUNTIFS([Risk or Issue?]:[Risk or Issue?], "Risk", ([Status], "Open"))) I can't seem to get it to work. Can anyone help? Thanks
I work for a small company who manufactures kitchens in Oxfordshire. We are able to make 9 kitchen units per day, 4 days a week - so a kitchen that has a total of 27 units would take 3 days to complet…
Hello everyone, I am looking for some creative support with a sheet that compiles milestones and dates from other trackers to an aggregated sheet with linked cells. The purpose is to share dates/miles…
I am setting up a sort of hybrid project with a large cable manufacturer, the project started and stopped during COVID and they had no task management. I am to use SmartSheet for the project plan, whi…
I have the following setup: An Individual Project (Individual) A Dashboard Rolling Up Projects Assigned to an Individual (Program) A Dashboard Rolling Up All Projects (Portfolio) Each of the Individua…
I have a sheet with a bunch of site location data. This sheet includes a check box column showing if the site is Open (Checked = Open). I have another Project sheet where I want to pull in only the OP…
Hello, I am using Smartsheet for project planning. I would like to track adherence to plan, specifically counting the average of the Start to Plan and Finish to Plan and represent the number separatel…
I have two sheets that workflow to a separate sheet. One sheet will put the cells at the top and one will be brought to the bottom. How can the cells be workflowed to the top of the separate sheet.
Hi, I want a formula to report if the Actual Start date is greater than the Baseline start then put the tick and cross symbol. The formula works however even when there is no actual start date entered…
I was wondering if someone could please help with linking! I have attached two photos for a reference. One is of the checklist (which is the one with the rows) and one is the report (which has all the…
