ContributionsMost RecentMost LikesSolutionsConditional DropdwonHello, I am making a ticketing application. The idea is that the person who opens a ticket, will see a Text - Multiple Choice field named "Attention". They will then choose between IT, Merchandising, or Facilities. The issue is I'm unsure how to go about making a dropdown that would change based on the three. I tried making a table for all three of the topics and played with the conditional settings a bunch but no luck. I will also add my relationship between the tables below. Thanks and any help would be very appreciated. ------------------------------ Brandon Hermez ------------------------------ Re: creating specific formula (if, then, else?)Hi Paul, Thank you so much so far! I tried your formula: If(IsNull([inventory on hand]), 0, [Par] - [inventory on hand]) i'm still getting the par as my result to order instead of 0 when my on hand inventory is null Any other idea? Thank you so much! ------------------------------ Brandon Hermez ------------------------------ Re: creating specific formula (if, then, else?)So I tried this and It asked me to put a number after the semicolon, so i put the [Par] - [inventory on hand] and i'm still getting the same result. The issue is if the on hand is null then i want the order amount to be 0, and it only does the equation (par - on hand) when someone enters in a number for the on hand inventory. The par is always static so right now in the order it is always showing that static number when on hand inventory is null ------------------------------ Brandon Hermez ------------------------------ creating specific formula (if, then, else?)Hello, I want to create a numeric formula where if one cell is empty, then i want the the formula to give back 0, else, if it has a number inserted, then i want the outcome to be another cell - the number inserted cell 1st Cell) Inventory par (always going to be 9) 2nd Cell) Inventory on hand (insert a number) 3rd Cell) Inventory to order (0 if nothing is inserted, otherwise ([inventory Par] - [inventory on hand])) Please advise, Thank you ------------------------------ Brandon Hermez ------------------------------