Spreadsheet formula for app sheet

[Siddarth_K]

Hi Sir,

I have created a if condition for the spread sheet table and the condition is when I select the model as OCE PW 300/350 the part code column reflect with the respective part code. hear is the If condition =IF(C3=“Oce PW 300/350”, “6826B001”, IF(C3=“Oce PW 340/360”, “6826B003”, IF(C3=“Oce PW 345/365”, “1284C001”, IF(C3=“TDS 700”, “6362B001”))))

but in the app when I update the data with various models the part code reflect the same as 6826B001 in the excel

I have check the if condition in the spread sheet and its works fine.

Please help me with the solution

Link for the app : https://www.appsheet.com/start/6875961e-9f4a-45c8-9920-66ef9f5497fe