@Chadd<\/a> <\/p>Simplest way to do this is to have a hidden column in each sheet with a column formula to add a sheet name into the cell when other data is added to the row.<\/p>
i.e. =\"Sheet 1\" (or whatever works for you), make sure it is a column formula.<\/p>
You can use that to identify where the row of data came from and to sort or filter the data in reports.<\/p>
Hope that helps<\/p>
Thanks<\/p>
Paul<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-18 17:48:58","updateUser":{"userID":154725,"name":"Chadd","url":"https:\/\/community.smartsheet.com\/profile\/Chadd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-18T18:09:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":333,"urlcode":"Workflows in Smartsheet","name":"Workflows in Smartsheet"},{"tagID":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":97927,"type":"question","name":"Using Formulae within Smartsheet Reports","excerpt":"Hi all, I am working on a project to aggregate data on a pan-European level with different Smartsheet files, a file per country. I bring all these different country Smartsheet files together using the Smartsheet report functionality. Some of the country data is in local currency and\/or in square feet. I would like to have…","categoryID":321,"dateInserted":"2022-11-18T11:42:09+00:00","dateUpdated":null,"dateLastComment":"2022-11-18T15:28:03+00:00","insertUserID":155114,"insertUser":{"userID":155114,"name":"BramdR","url":"https:\/\/community.smartsheet.com\/profile\/BramdR","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!2V8u_kpssPo!3Ejsvz5QgLo!hia0290amPc","dateLastActive":"2022-11-18T15:57:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":126598,"lastUser":{"userID":126598,"name":"Paul McGuinness","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20McGuinness","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-18T16:32:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":26,"score":null,"hot":3337557612,"url":"https:\/\/community.smartsheet.com\/discussion\/97927\/using-formulae-within-smartsheet-reports","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97927\/using-formulae-within-smartsheet-reports","format":"Rich","tagIDs":[254,265],"lastPost":{"discussionID":97927,"commentID":351688,"name":"Re: Using Formulae within Smartsheet Reports","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/351688#Comment_351688","dateInserted":"2022-11-18T15:28:03+00:00","insertUserID":126598,"insertUser":{"userID":126598,"name":"Paul McGuinness","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20McGuinness","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-18T16:32:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-18T15:57:28+00:00","dateAnswered":"2022-11-18T15:28:03+00:00","acceptedAnswers":[{"commentID":351688,"body":"
Hi @BramdR<\/a> <\/p>The report will pull in the columns from each of your country sheets but cant perform an active calculation on that data.<\/p>
You will need to perform the conversions in the country sheets and then pull through those aligned EUR and sqm columns instead of the local country data.<\/p>
So its most likely you will need to add two columns to each of those country sheets to hold your formulas and the converted EUR and sqm values for each row etc.<\/p>
Hope that helps<\/p>
Thanks<\/p>
Paul<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-18 15:57:28","updateUser":{"userID":155114,"name":"BramdR","url":"https:\/\/community.smartsheet.com\/profile\/BramdR","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!2V8u_kpssPo!3Ejsvz5QgLo!hia0290amPc","dateLastActive":"2022-11-18T15:57:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">