-
Smartsheet Automation Problem
Here is a very simple automation which says that if a row is added or changed, and the value of Status is blank or 'On Hold', then change it to 'Backlog'. Now i add two rows, first has status blank, and second has status 'On Hold'. The automation changes the value of second row and not the first. Anyone has an idea why? Is…
-
Modify Sheet Summary field
Currently have a field in my sheet summary with this formula: =COUNTIFS(Finish:Finish, <=TODAY(+14), Finish:Finish, >=TODAY(), [Helper Parent Column]:[Helper Parent Column], <>"", Status:Status, <>"Complete") I would like to add if the Status is "Not Needed". How do I modify the formula?
-
Current Date + 6 months
Hello, I'm trying to figure out how to designate (highlighting or change text color) a Project that has an end date of 6 months from the current date within a grid. Here's an example grid. I figured out conditional formatting using a certain number of days but is there a way to do a specific number of months? Thank you.
-
CTRL+e for details conflicts with Chrome Browser shortcut / hotkey
Typing CTRL-e in the Chrome Browser opens a Google Search in the address bar instead of showing the details view in Smartsheet as intended. Can you think of any way around this conflict?
-
How to combine multiple project plans into one, but keep separate editing access?
I am running a program that contains 17 different workstreams, and each workstream has a separate PM that is running their own individual plan. We want a view where you can see all of the workstreams together in a 'program' plan. We consolidated all plans into one but this has created a large number of issues as we have 20…
-
Can Smartsheet be utilize for scheduling?
We are hoping to utilize Smartsheet as a bit of a booking software, where a user can choose a time to be booked in for. In theory then this time would then not be available for others. As well as setting a limit on when the time is allowed?
-
Report Doesn't Have the Option for Grouping, Sorting or Filtering
I have a report that is referencing a control center program. Other users that are setup as leads on the program and have the same admin permissions I do are able to edit the Group, Filter, Summarize and Sort settings of this report, but I can not. When I click the Columns button it just says "Loading" and even if I leave…
-
User Rights
I am the only licensed user in my Smartsheet Pro account and the owner of my workspaces. However, all newly created sheets show me only as Admin, not Owner. This prevents me from performing actions like moving or copying rows between sheets. It seems like my account is not recognized as the actual owner in the backend.…
-
Web Content Widget displaying dashboards scrolled to the bottom by default
Hi Community, I am using the Web Content Widget to display multiple Smartsheet dashboards on a centralized "master" screen. I’m struggling with a display issue: when the main dashboard loads, all of the embedded web content widgets automatically scroll to the very bottom of their respective views. This forces users to…
-
Can I link a template on a dashboard widget?
I work in the Transformation Office and one way I use dashboards is for governance. I call it the Transformation Office portal, and it's a place for anyone in the company to find the templates they need to submit a project idea. The issue I have is that the widgets on that portal (dashboard) open up other items, like other…
