Sum a column referenced from one sheet into another.

Options

suprman1117

suprman1117 ✭

08/04/23 in Formulas and Functions

Hi,

I'm new to smartsheets. Is there a way to calculate the sum of values in a column on one sheet and show the total on another sheet?

Thank you,

Chris

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

08/04/23
Options
Yes. You would use a formula with cross sheet references.
https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

How to count unchecked boxes for rows with data only
I tried this formula but it's also counting the unchecked rows without data =COUNTIFS([Client Lost?]:[Client Lost?], 0) What should be the correct formula?
Risk Rating Formula
Hi all - I am trying to create a long formula and need some assistance. For a Risk tracker I have 2 columns (Probability and Impact) both which have list values of High, Medium, Low. Based on those selections I want to have a 3rd column which is the output of the formula, Rating, designated High, Medium, Low. Below are the…
COUNTIFS with multiple inputs and dates
I'm trying include a date range with counting the number of applicants within various depts, in certain date ranges, but it's saying incorrect argument set. =COUNTIFS(DISTINCT([Name of Requestor]:[Name of Requestor], [Submission Date]:[Submission Date], AND(@cell > DATE (2023, 9, 30), @cell <= DATE(2023, 12, 31))))…