-
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…
-
Automatic inclusion of new sheets within a report
Am I wrong to assume that new sheets will be automatically included in a report when I select a folder level of sheets when building the report? Currently I'm having to manually go back and re-select the folder level of sheets each time a new sheet is created inside that folder. The following screen shots show a before &…
-
Are automations shared with other users when the sheet is shared?
Hello, I have set up a Goods In mastersheet which I will be the owner of. Within this I have set up 13/14 automations to notify different users when they receive a parcel. I have then shared this sheet with the Goods In Manager who will be inputting the data onto the sheet, will these automations also be shared with him or…