-
Anyone else getting a 406 Not Acceptable Error when going to Help Desk
The "? --> Help and Learning" link in the lower left corner is producing a "406 Not Acceptable" error. Upon further investigation, I can get to https://help.smartsheet.com and any of the links within, however, from there if you select Contact Support in the upper right corner, and then Get help within Smartsheet, you get…
-
Admin Access not working for Dynamic Views
Hello everyone, I'm Yashvardhan Vats. I have admin privileges for the Smartsheet source sheet (screenshot #1) and the relevant dynamic views (screenshot #2) , yet I'm unable to view the admin functions in dynamic view sheets (screenshot #3). I'm missing the blue gear icon displayed in the top right of the right of the…
-
Changing cell value based on another cell
Hi all, After tackling several programming languages I have a seemingly simple task that I got stuck with in Smartsheet. Let's say you have Score and Max Score columns in a row. Score is changed by automation. It can go up and down. I want to store the value of Score in Max Score but only if Score is larger than Max Score.…
-
Dynamic Report - read description, it may not be what you think
I built reports for each of the leaders (roughly 20) of a group in our org based on filtering the data the report is looking at, by the leaders names. When these leaders move to different positions or leave, I have to manually go into each report and change the filter to the new leader. Is there a way to reference a…
-
Remove checkbox on select rows
I was exploring some Smartsheet templates and found a unique feature in the below template set. In the sheet they were able to remove checkboxes in the "Done" column by typing anything other than a 1 or 0 in that cell. I tried to replicate this behavior in my own sheets and was unable to do so. When I type anything into…
-
Is there a way to ONLY display the Gantt chart in my dashboard widget?
For this particular use case, we only want to see the Gantt cart and don't care about the data in the left pane. I want to be able to show a real time timeline display in the dashboard. But the widget not only displays the sheet view of the data, but it seems to favor it as well limiting my ability to set the pane size…
-
Can we filter columns?
When we customize our filter settings, I know that we can filter rows, but can we filter columns?
-
Count Collect formula assistance needed
Hey all, I'm using a Count Collect formula I grabbed from the PMO template as a baseline. Here's the original formula: =COUNT(COLLECT({Task ID}, {Task Status}, "In Progress", {Task Health}, $Label@row)) Only thing I changed from the PMO is instead of "Project" I changed it to "Task". I'm trying to get similar metrics on…
-
Can I conditional format specific cells only?
I only want the rows under my "STATUS" parent row to change colors. If status is less than 0, turn red. If 0 or greater, turn green. I figured out a workaround, but it's still turning other numbers in the column green. If I try to define a custom criteria when in the rule, it only allows for specific numbers, not the cell…
-
Contact Selection Drop Down
Hello. We have an employee who changed his email due to a status change. His original email used his common name of "Tony." His new email used his formal name of "Anthony." It's been a while since we made the change in Smartsheet, but we either deleted or just changed his profile to reflect the email/name change. So his…