I have a SharePoint table which is populated from a Form. I'd like to complete a record in a column based on responses elsewhere in the form. I've successfully created an IF statement based on what's been selected:
I'd like to append in the same column to the output of the above further IF statements, relating to Location (Working from Home, Office Based etc), then Operating System (Windows, MacOS, Linux, iOS). For context this is to automatically create a device ID for inventory logging based on a Form.
It will give you results like L-IND-Win (example).
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.