-
Incomplete work left to go
Is there a way to calculate work days "left to go" where the task is not marked complete while ignoring simultaneous tasks (tasks that have the same predecessor)? It seems like networkdays should get part of the way there but it seems like i need an "if" statement to look at complete. Is there another way to get there that…
-
Excluding Sheets in a Report
I'm a little confused, in some of my reports under the "Where?" I have a checkbox option that allows me to to report on all sheets excluding the ones I have checked. I'm trying to build a new report that is going to report on a majority of our sheets except a select few. I'd rather include them all and exclude the few…
-
Is it possible to have Sheet A populate information into Sheet B if a checkbox is checked?
Is it possible to do the following: Sheet (A) - A checkbox is checked in Row 4 Sheet (B) - Automatically pulls in a text-field that is in Row 4 If so, how? The purpose is to roll all "At Risk" Description Fields into a summary sheet for the executives to review. Reports won't work for they need to be able to type their…
-
SmartSheet Reports
Hi all, My reports are not being updated. I have logged out and refreshed the report builder but still no updates or changes. Anyone else having similar issues?
-
Numerous issues in last few days
Have others been experiencing any unusual activity in the past few days? I have been having a number of issues that appear to be related to permissions and reports e.g. A report we use daily suddenly showed a permission error for one of the users in the team although their permissions have not changed and they are owner of…
-
RYG Automation using Drop Down lists
Hi I've watched a few videos on RYG automation based on due dates but is anyone able to help with the IF function using categories from a drop down list instead? I.e. Looking at Recruitment Status: If someone chooses 'On Hold' from the drop down, I want the RYG column to show Red. If someone chooses 'Interviews and…
-
Critical Path Tasks
Hello, I would like to ask how I can create report for critical tasks ? Regards,
-
Report with only parent rows
I am new to Smartsheet and I'm trying to create a report from multiple sheets that have parent rows and child tasks. I'm looking for a report that puts together all the sheets but only shows the parent rows from each sheet along with the information on that row - percent complete, gantt information etc.
-
Reports showing wrong criteria
Hi I have been using reports for a while now and everything has been working fine however lately they have been including results that do not meet the criteria I have specified. For example I have a report that's criteria is Column 1 is Yes and Column 2 in not checked that they will appear on the report. However lately the…
-
Card view for reports
Hi All- I really love the card view but can't figure out how to see my reports in card view. I understand that there has to be at least one drop down menu for card view to be an option but it doesn't look like we have the option make any of the columns in a report with drop down menus. Is that correct? Is card view not…
