How can I use an IF statement with INDEX/DISTINCT?

Desiree500 ✭✭
edited 12/07/22 in Formulas and Functions


I am trying to pull distinct information from a different sheet if a box is checked.

Here is my formula to pull in the distinct information:

=IFERROR(INDEX(DISTINCT({Source Sheet Column_Name}), ID@row), "")

Now, I have a checkbox column called AX S2 and I just want the information from the rows that are checked in this column.

So, if the AX S2 column is checked, then pull the information.

Thank you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!