-
How to give access to specific people ONLY to specific columns of a master sheet?
Dear Smartsheet team, I would like your input on the following topic: We have created a Workspace for one of our customers, that contains a master sheet that stores Tactics, with various different columns. We have a request from our customer, to add 4 more columns to this master sheet, related to the Tactics, and give…
-
When will increase in cell limits be implemented?
I attended last year's Smartsheet Engage and there was a big announcement that Smartsheet would be increasing cell maximums in sheets - from 500,000 to 5 million. Any more word on that? When will these new cell limits be implemented? I have several big projects I'm holding off on until the increase happens.
-
Bi-directional update between 2 sheets without report?
Hi, is there any workaround that allows for bi-directional updates between two sheets without the use of a report? For example, Sheet 1 has Unique ID and Status columns, same goes for Sheet 2. What I want to be able to do is if either the Status column gets updated for a project in Sheet 1 or Sheet 2, the information will…
-
Pesky COUNTIFS with OR formula
Hi everyone, I have one of those pesky formulas that is giving me a hard time. This is for a Summary Sheet I'll use to build a dashboard so I'm referencing another sheet with the data. Here's what I am trying to pull...Count if the following is true: 1) Project name is the same as the project in the summary sheet 2) Month…
-
Folders within a workspace should sync just like the workspace itself when creating a report.
I recently discovered that a folder within a workspace (which has the look and feel of a folder) does not function in the same way as the workspace itself. When creating a report I may want to focus on a subset of items in a folder and ensure that it syncs anything within that folder. In my case, my workspace contains…
-
Assigning to a group of people
Would it be feasible to assign a task to a group of people? I am not asking to assign a task to multiple people, but just to a group. To have more background: in our company we have around 15 scripters (they program our questionnaires on an online platform). So if project managers want to assign a task to the group, they…
-
Merged: Column Header Color Fill
This discussion has been merged.
-
Filtered Sheets in Developing Reports
I have a report that is filtered by a particular folder within a shared workspace... everytime I remove items from that folder the report no longer watches the folder, and it turns into individual items within the folder... Is this common behavior? Has anyone else experienced this behavior recently? I want the subfolder to…
-
Formula to split up / break down long strings of text
Hi, Hope you're all keeping well. I was hoping someone could point me in the right direction of a formula / function that can help break down large sections of text. If someone could point me in the right direction, I should be able to work out the nuances and implementation myself. I have an API that exports data into a…
-
Cross-sheet references maxed out
I'm building a large master reporting sheet that cross references multiple other form response sheets based on a shared "incident number". I have six more columns of data to pull over from another sheet but have maxed out the cross sheet references (100 per sheet!) This master sheet then uses that data to create pdf's. I…
