linked sheet update

Bryan Zheng

Bryan Zheng ✭✭✭

05/04/23 in Formulas and Functions

HI,

I am creating a sheet for our billing department. The sheet is based on the information entered/updated on another sheet. I did link the entire column of the main sheet but the information is not updating when the main sheet updates. As the screenshot below, is the one that I made for the billing department. What did I do wrong?

Thanks,

Tags:

0 ·

Best Answer

Paul Newcome Community Champion

05/05/23 Answer ✓

https://help.smartsheet.com/learning-track/smartsheet-intermediate/reports

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
0 · Share on Facebook Share on Twitter

Answers

Paul Newcome Community Champion

05/04/23

What is the purpose of the sheet?

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
0 · Share on Facebook Share on Twitter
Bryan Zheng ✭✭✭

05/04/23

https://community.smartsheet.com/discussion/comment/374496#Comment_374496

HI Paul,
The purpose of the sheet is to inform the billing department of the payment status for each individual client and how they paid.
Thanks,

0 · Share on Facebook Share on Twitter
Paul Newcome Community Champion

05/05/23

Have you looked into creating a row report from the source sheet instead?

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
0 · Share on Facebook Share on Twitter
Bryan Zheng ✭✭✭

05/05/23

https://community.smartsheet.com/discussion/comment/374602#Comment_374602

More details please. Thanks

0 · Share on Facebook Share on Twitter
Paul Newcome Community Champion

05/05/23 Answer ✓

https://help.smartsheet.com/learning-track/smartsheet-intermediate/reports

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
0 · Share on Facebook Share on Twitter
Bryan Zheng ✭✭✭

05/08/23

https://community.smartsheet.com/discussion/comment/374630#Comment_374630

Thank you. I will try this out

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

My formulas on my Metric sheet are calculating 0 and I'm not sure why
Hello, I am trying to create a dashboard with widgets to display our overall progression on multiple projects. I was told a Metric sheet would be best to do this. I am creating my first metric sheet but the formulas are calculating 0 and I'm not sure why. In the first section below I am wanting to add up how many projects…
Form field controls so data entry is required to sum 100 percent?
We're sending out a survey to understand how much time employees are spending working for each of two departments. We want employees enter time spent as a percentage to add up to 100%. For example an employee might enter 40% for dept "a" and therefore they have to enter 60% for dept "b". Or better yet, whatever they enter…
How do I use Cell reference in a formula when using Index?
I have a simple table that has the following columns (along with other columns), ZZZ YYY 10 15 and I would like to replace the ZZZ and YYY in the following formula =INDEX([Thing1]ZZZ:[Thing2]YYY, 1, 1) With the data from the columns above so that the resulting formula would be: =INDEX([Thing1]10:[Thing2]15, 1, 1)