Apr 06 2022 08:14 AM
Hello,
I am trying to set up a formula that will a allow a user to click on a cell next to a cell with text in it that will then transfer the text to a sperate sheet when chosen, is this possible?
Apr 06 2022 09:13 AM - edited Apr 06 2022 09:19 AM
@Danlach1220 Yes, this should be possible. You can ask people to put an x in the box beside the text and then write an =IF( ) formula that will copy the text in the cell beside the x to the separate sheet as long as the x is present. If the x is absent or if they type anything else in the box besides an x then it will leave the cell in the other sheet blank.
See attached for example