Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 25, 2018 01:52 PM
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?
Dec 25, 2018 02:20 PM
[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.[Conferences]
table, add a Lookup field that points to {Review if Attending}
Dec 25, 2018 06:01 PM
Thank you again for the help!!