Roll up Sheets

PLS

PLS ✭

03/22/18 edited 12/09/19 in Smartsheet Basics

I have multiple sheets from different workspaces that need to be rolled into one sheet. What would be the best way for doing this?

Tags:

0 ·

Comments

Tim ✭

03/23/18

Do you need to sum the contents or collate the data in consecutive rows?

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Fairly new to Smartsheets - Having trouble with a countifs / date formula. Need your help!
I have a "master data" sheet that has a "DATE OF INCIDENT" field column, and a "FOUND ON A SCHEDULED INSPECTION" field column that populated as either yes or no. These are the two references I'll want to use in my formula on my metrics sheet. In my metrics sheet I want to use a COUNTIFS statement to tell me how many passed…
A workflow has become invalid
Hi, I received an email saying that one of the workflows of a particular sheet has been deactivated. The action for this workflow is so simple, so when the column in another sheet is changed as "completed" the row is copied and moved to a master sheet. It is important to mention that we have been using this for months and…
Permissions Workspace vs Sheet
I want to set a Workspace permission for all members (except Owner and 1 Admin) to Editor - Can Share, which I'm able to do. Within that workspace are some files that I want some of the members to have Admin permission, but still only have Editor permission for the other files in the Workspace. When I open the sheet for…

Help shape the future of Smartsheet.
Share your ideas and feature requests.