Hello,
I need some help i have a table with multiple columns (Ratecon, BOL, COD and status) what im trying to do is if someone upload file in Ratecon column then the status field shows booked otherwise empty, then if someone upload file in BOL column then status field shows pickup otherwise empty and if some one upload document in COD field then it shows delivered otherwise empty. Also if all three columns have attachments then it shows completed in status column otherwise empty.
I just want to know how to perform this task any help will highly be appreciated.
What if 2 out of 3 file columns have a value?
I thought it before but if its not possible then what’s the best practice to accomplish this task? Should i go for manual process or there is some possibility for automation. I need some help to understand this workflow.
Huh? You thought what before? The answer to my question?
This is certainly possible, but you left out part of your logic, thus my question.
You’ll need to use IFS()
https://help.appsheet.com/en/articles/2355961-ifs
I thought if its possible or not because it has multiple conditions as you already aware that I’m a beginner not a professional like you. So let me check how its working at my end.