Review the functions list link below and filter on "Advanced" to see more advanced functions.
Cross-sheet formulas are a powerful and flexible way to connect data across all of your work in Smartsheet. By quickly creating data connections across multiple sheets, you can then organize your information more efficiently, make more-informed decisions, and act faster. Review some of the most popular cross-sheet formula functions, including VLOOKUP and COUNTIFS.
Step through an example scenario that demonstrates how to use VLOOKUP and COUNTIFS in cross-sheet formulas.