Hi all. New, enthusiastic user here hoping for some guidance. In setting up a repeating process, I have dependencies/predecessors clearly identified. Wonderful! Now, how does one set an alert/notifica…
Hello everyone! I am at the beginning of making some operations sheets for my job and will need to rely on column formulas I have successfully input a formula in a cell and it works! When I drag the f…
The Problem: JIRA is actually not auto syncing like it should to pull in tickets automatically into smartsheets Notice: The workflow is set correctly to sync JIRA fields to smartsheets The Problem: We…
Hi I need help in doing a count ifs in another sheet. My countifs formula currently works in the summary section of the sheet but when doing a sheet reference it doesn't. The working countifs formula …
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…