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โ
)
Dear Sir,
Thanks a lot it really help me
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |