Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

How to pull in information with conditions

Topic Labels: Formulas
618 2
Showing results for 
Search instead for 
Did you mean: 

I have a table called “Conferences Costs”
I have a table called “Conferences”

In Conference Costs, I pull in the conference name from the “Conference” table. After that I have a column called “Year in Review”. This is the year that the conference falls under for budget reasons. I also have a column that has a check box “are we attending?”.

In the conference table, I want to pull in Year in Review information but only if the checkbox is checked.

How would I do this?

2 Replies 2
  • In your [Conference Costs] table, add a formula field called {Review if Attending} or something. Use a formula like this: IF(AND({Year in Review}, {Are we attending?}), {Year in Review},BLANK()). This will repeat the Year in Review information only if you are attending. You can hide this field from view if you’d like.
  • In your [Conferences] table, add a Lookup field that points to {Review if Attending}

Thank you again for the help!!