Using Formulae within Smartsheet Reports

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 all data in EUR and in square meters and was hoping to add a new column in the report where I can add a formula that reference a mapping table to pull in the right exchange rate and conversions, so I can convert everything into Euros and square meters.

I have not found anything that shows that this is possible? Does anyone have experience with this and/or know if this is possible?

Thank you in advance!

Find more posts tagged with

Formulas

Reports

Accepted answers

Paul McGuinness

Hi @BramdR

The report will pull in the columns from each of your country sheets but cant perform an active calculation on that data.

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.

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.

Hope that helps

Thanks

Paul

All comments

Paul McGuinness

Hi @BramdR

The report will pull in the columns from each of your country sheets but cant perform an active calculation on that data.

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.

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.

Hope that helps

Thanks

Paul

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.