cross sheet formula with multi-select range?

Options

Matt Stewart

Matt Stewart ✭✭

01/20/22 in Formulas and Functions

ive got a database of resources with various teams and departments people are on. in some cases there is multiple teams someone is on. How can i use HAS or CONTAINS with a cross sheet index/match?

Tags:

Formulas

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

01/20/22
Options
Are you able to provide more detail as well as a screenshot for context?

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

Formula to surface specified data and date from project task
I am trying to to surface to latest EOT from the task to row 1 on EOT Stage, and respectively the corresponding End Date to EOT End Date row 1. We may state EOT 1 - 5 on the project sheet, but it will only take effect the date is filled in. Therefore, the latest EOT need not necessary be 5. But in the following example, I…
COUNTIFS formula for any future date?
Hi all, I am trying to create a COUNTIFS formula that counts if the due date column on another sheet is today or any future date. I tried =COUNTIFS({due date column's range}, >=TODAY()), but it is not working. Any advice would be appreciated! Thank you.
Sheet Summary Field - Count Value from Dropdown
What's wrong with this Formula? Getting an Invalid Ref