Spreadsheet formula for app sheet

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

Please help me out

Hi,

IFS() many help you here.

Dear Sir,

Could you please help me in writing the statement for the IFS 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”))))

This needs adding to the app formula for the column in question.

ifs(
[Column Name]=“Oce PW 300/350”, “6826B001”,
[Column Name]=“Oce PW 340/360”, “6826B003”,
[Column Name]=“Oce PW 345/365”, “1284C001”,
[Column Name]=“TDS 700”, “6362B001”,
TRUE,”6362B001”
)

1 Like

Dear Sir,

Thanks a lot it really help me