Hi,
I'm having an issue with the FINDROW function. What I am trying to do is auto input the calorie value for the food item that was picked from a picklist, but running into an error.
Here is what I am trying to do:
1.) user makes a selection for their 'Food Item'. The options are coming from a picklist that pulls from table called 'Item_Picklist'
Table 'Item_Picklist' below:
2.) What I am trying to do is leave the 'Calories' part of the form blank, BUT if they select a 'Food Item' that exists in table 'Item_Picklist' I want to auto input the 'Calories' data.
I input this formula for the initial value for the data cell, but am running into #VALUE! error.
I'd expect for the value of '136' to be picked up and auto inserted when 'Rice' is selected as the food item.
Through some testing I seem to run into an error issues when using FINDROW that has a condition that compares a column form a table that isn't a rowlink to a the app form input that is set up as a picklist. Is my formula wrong or is there a workaround to comparing picklist input from the app form to a table column that isn't formatted as a rowlink?
Thanks!