-
Report in Dashboard won't scroll all the way down
Hi, I have a report I've embedded in a dashboard, which contains 261 rows. The report only allows me (and others) to scroll down to the M's and then a link shows up that says "open source report to view more" and provides a link to the report. I have another report embedded in the same dashboard, but that one allows me to…
-
Duration Column with Dependencies Enabled
Hi All, So with the duration column, we have decided to enable the dependencies however the calculation seems a bit off To test it we but in 2 days for duration Dependency is Start Date and Due Date We thought that if the Duration is two days. We put in a Start Date of 9/1/2020, then the Due Date should be 9/3/2020.…
-
SUMIFS with multiple OR criteria using CHILDREN?
Just curious. Looking for a way to speed up this scenario: =SUMIFS([Range to sum]:[Range to sum], [Criteria range]:[Criteria range], OR(@cell = [Criteria]1, @cell = [Criteria]2, @cell = [Criteria]3)) Is there a way to transpose that OR statement into something using CHILDREN so that I can plop a list of a large number of…
-
How do you collaborate in Smartsheet?
We want to hear your Smartsheet collaboration stories! Comment below with your stories of how you moved work forward using successful collaboration, and tune into ENGAGE this year on October 1 to learn more about CWM solutions. We look forward to hearing from you!
-
Is there a keyboard shortcut to minimize sub categories/tasks in grid view?
I have thousands of lines in a SS with lots of categories and sub-categories with tasks within them. I like to navigate the ss using my keyboard. Is their a keyboard shortcut to minimize categories? For example, can I toggle the "-" or "+" signs on the lines in the attached photo using my keyboard? (see photo) Thanks!
-
Form Conditional Logic leaves unwanted fields
Hello, I have a form that starts with 3 dropdowns that will be common to everyone - everyone will have to fill them out. The 4th field is where I am implementing the logic. I want it to be that if a user picks one of the options in the dropdown, the form will then display only the fields I pick in the logic rule. I can get…
-
Can we decide who receives emails when the comments are added?
I use Smartsheet as a request system for our team. We will have tickets that are assigned to the members of our team and the tickets are submitted by anyone. I want to customize who received emails when the comments are added. For example: If the person who submitted the request (Requestor) has added comments, I want an…
-
Dashboard Report data right justified
I have a dashboard with 4 report widgets. Two of the widgets show the report data right justified. The source sheet and report both show as left justified. Anyone experience this issue? Any idea how to get the widget to show the report data as it is in the report and source sheet (left justified)?
-
Cyrillic /slavic characters appear as code
Dear Colleagues, In some of our Smartsheets, gathering input from third-party collaborators, they write their input into Cyrillic. While some text appear fine, a number of entries include the text as well as set of html-like characters. We did not manage to figure out why and when it happens, and how to prevent that. I'd…
-
Widen attachment column
My attachment column is so narrow you can't see the paperclip icon. I can not click and drag it wider. I need colleagues to be able to see the symbol so they know something is attached. How do I fix this?
