
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 18, 2023 04:43 AM
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 🙂
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 23, 2023 04:38 AM
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
