-
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…
-
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…
-
Formula based on last modified date that skips weekends
Hi there, I'm building out a new sheet where I utilizing the system's "Last Modified" date column. I tried to trigger a workflow off of this column that sends an update reminder if it hasn't been modified in 2 days, but the column is not showing up as an option (presumably because it's system generated). With that in mind,…
-
Show sheet data in the Form View
Our PMO is using Smartsheet to intake project requests from the business users via our intake form - which we love. However, once the project is submitted there is no particularly good way to have the request data that is in the sheet visible back to the business users (requestor, project owner, executive sponsors,…