Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula IF statement pulls data from a specific row + cell

Topic Labels: Data Formulas
909 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Cassy_Amelia
6 - Interface Innovator
6 - Interface Innovator

Hi,

Not sure if this is possible...

I'm looking to create a formula that checks the condition of a single select cell called {Alt Shop}. IF empty use {Discount Code} if it contains "Shop Name" to use data from a particular cell in a particular row.

For example {Alt Shop} contains "GAP", use data from cell named {Discount Code} on row named "GAP".

Thank you for your help 🙂 

 

1 Reply 1

Hmm, if I were you I would:

1. Create another table where each record represents a shop with their discount code called "Shops"
2. In the original table, create a linked field to "Shops"
3. In the original table, create a lookup field from the linked field from the previous step displaying the value from the field "Discount Code" from the "Shops" table
4. In the original table, create a formula field with an "IF()", that will display the value from the lookup field from step 3 if a "Shops" record is linked, and if not, display the value from the "Discount Code" field from the original table