I had a couple of analytics columns on a dashboard that were locked and hidden, where I had a bunch of COUNTIF(S)s and SUMs (as a workaround without pivot tables) to create some charts for my dashboard. Turns out that when people change the sort, these analytics columns got messed up, and now my data is all over the place…
SalesForce connector only allows for Filtering Operator 'AND' and Not 'OR', why is this case and what is a workaround for a scenario. Type ID: Not Equal to 'ABC' OR Type ID: Not Equal to 'XYZ' ?
Hi there. Please tell me there is a way to modify an existing Datamesh config? Seems like I have to delete and recreate anytime I want to make a change to one.
Hi, I want to create a form that limits the selection to unassigned tasks from a master task list. The task columns is currently the primary column, so there is no limitation to create a drop down menu in the form. Is there a way to limit the options in a form with a filter? Thanks!
Hello Community!! I am attempting to build a solution set for an internal training/learning organization who has to go build very complicated trainings for technical staff. Each agenda will contain modules.... Modules will house the table of contents for topics needing to be covered under each module. There could be a few…
I have admin access and have set the Gantt settings on a particular sheet to Primary heading: Months Secondary heading:Weeks I have shared the sheet with another user and given them Editor - can share permissions but they are seeing a different view on the Gantt chart. Why is that? What do I need to do for them to see the…
When leaving Friday afternoon all of our sheets and our workspace was working fine. Came in this morning to find all of our sheets / work space totally gone.
Hi there, We have just started using a simple workflow to approve capital investment projects in the business. The workflow submits each project justification through a hierarchy of approvers, dependant on the value of the project. The workflow has minimum of 7 approvers in the process for a given project to gain approval.…
Greetings, I have the start day and the duration. Is it possible to calculate the end date using these two entitites such that only working days are included (only monday through friday and not the weekends)? Thank you
Greetings, I have a Smartsheet (Smartsheet A) with multiple date columns. These dates have been added using various formulae. I also link some of these dates into a master sheet (Mastersheet A) that consists of a Gantt Chart. The dependency settings on the Mastersheet A with the Gantt chart is such that there are only 5…
I have downloaded the access report and can see all of the sheets and their admins, viewers, tec. But the owner column is blank? We are transitioning to the new model and I need to know who the owners are. Thanks!
I'm always being asked questions as what is included on the free tier vs the license tier. It would be great to have a comparison features chart to reference that was up to date. Maybe there is one or someone has made one.
Hello, Is export selected rows to PDF disabled? thanks
Help shape the future of Smartsheet. Share your ideas and feature requests.