-
Urgent help needed - raport self locked all columns
Hi All, I have a sheet which is reported for two, exactly the same users. They have the same level of access to the report (as editors with no share options) as well as to the main sheet, but for some reason, one of them just lost ability to edit anything! All columns are shown as locked! Do you have any idea what could…
-
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…