Calculated Column to the report sheets?

I have a report sheet but that pulls in data from other sheets, I wanted to add another column that does the vlookup and gets the corresponding values from another sheet.

But in the report version, the only way I could add a column is by referencing it to other sheets. Is there any way I could add a column?

I can create another sheet but it won't stay dynamic incase I add more sheets or rows to the connect sheets.

Thank you

Find more posts tagged with

Accepted answers

Paul Newcome

You would need to add the column to each of the sheets and have the formula there.

All comments

Paul Newcome

You would need to add the column to each of the sheets and have the formula there.

Shadaab

https://community.smartsheet.com/discussion/comment/312779#Comment_312779

I was thinking that to be the last resort, looks like there's a lot of work for me now :-) Thanks for your reponse.

Paul Newcome

Happy to help. 👍️

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.