Formulas

Options

CherylAK

CherylAK ✭✭✭✭

03/13/19 edited 12/09/19 in Formulas and Functions

Is is possible to write a formula based on information in one sheet to put the result in a cell of another sheet?

I want to sum items if they meet certain criteria in one sheet but the result going in a cell in another sheet.

Thanks!

Tags:

Formulas

0 ·

Comments

Mike Wilday ✭✭✭✭✭✭

03/13/19
Options
Yes, it is using cross sheet formulas. Check out these articles/videos for more information:

https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets

https://www.smartsheet.com/blog/powerful-and-flexible-cross-sheet-formulas

https://www.youtube.com/watch?v=u01GHwmlDRA
0 · Share on Facebook Share on Twitter
CherylAK ✭✭✭✭

03/14/19
Options
Thank you!

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

Reference sheet CountIf Contains
Hello, I am trying to build a reference sheet that gives a summary of quarterly results. I need to count the row if the value contains either Exception or Samples. I tried many different versions only getting many different error messages. This is my last attempt getting a Invalid Operation. =COUNTIF({2023 Q4 Monitoring},…
Calculating Formula help
My goal is if total number of students is 0 then it should equal number of students then in Total students the formula will be total number of students minus number of students
IF OR Statement
Hi There! Looking for help to on an IF OR statement. Want to take two columns that will be either Yes or No, and populate another column with a date from two columns if it is Yes. Process, either the Facilitator or the Architect will be requesting a Complete By Date. Whichever requests, the other has to say yes or no. For…