-
Would like to create a filter that hides completed tasks BUT only when parent row is checked
Hi there, Ultimately I would prefer that tasks that are completed are archived, however in lieu of functionality, I am looking to create a filter view where tasks marked as "done" are hidden. The problem is right now the filter hides ALL tasks marked done and I would prefer it hide ONLY the parent and its subtasks. Please…
-
Dashboard Chart
Hi, Anyone saw this error before when trying to add more than 4 columns and 5 rows? "Selected data cannot be charted" Thank you!
-
Share Permissions on Reports
Question: Why in the article on Sharing Permission Levels does it say there is a commenter permission in reports but that option is not available when I go to share it? I thought I might need to give this permission at the sheet level first, I tried this but I still do not see the option to share the report as a commenter.…
-
Update Master Sheet with multiple source sheets
I am trying to figure out a way to update my master sheet with information from multiple source sheets. For example, I have 10 departments. Each of those departments has their own employee information sheet. I need the master sheet to update not only as rows are added, but also update those rows as information in the…
-
Pie charts legend/series
I've created a pie chart widget to pull project status from a task list by person, but when there is only one status per person and the pie chart shows 100%, the legend shows the series name (Status) instead of the value (Overdue). Any idea how to fix this? (Also, is there a way to make all the pie charts have the same…
-
number of different items, consider similar items once
Hello there, I am looking for a formula/function which can give me quantity of different items. something which gives me 3 (David, Sarah, Mark) if I apply it for Column 1, and gives me 2 (24, 43) if I apply it for Colum 2, on the below sheet: Note: I don't want to type David, or Sarah, etc, in the formulas because there…
-
Dashboards & Reports
I have created an announcement report for announcements on Dashboards. I highlight the most recent entry in the report, but when I view the report in the Report Widget on the Dashboard, the row is not highlighted. Grid/Form--> Report --> Dashboard How do i get it so my formatting on my report appears in the Report widget…
-
Can I filter by color ?
Hi, I would like to know how if it's possible to filter by color.
-
Hello, I cant seem to get my "at risk" column formula to work. I keep getting #Unpars error message.
Here is the formula I'm using: =IF(AND([END]3<TODAY(),NOT(Status3="Complete")),1,0)
-
Is there a way to protect an online form used to populate a SmartSheet?
I have a form that I use to gather data. I send the user the form, the user enters the data and clicks Complete and the data is then added as a new row in my SmartSheet. The questions in the form are very confidential and I don't want someone inadvertently gaining access to it. Is there a way to protect who can open that…