Calculated Column to the report sheets?

Shadaab

Hi

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

Paul Newcome

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

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. 👍️