User Profile
H-M-P
Copper Contributor
Joined Apr 12, 2021
User Widgets
Recent Discussions
Change SPO List Details Pane to Custom View Form
I have a SPO list for which I've customized the New, Edit, and View forms. The customized View form opens when you double-click an item when in list view, but if you select an item and then click on the "open the details pane" icon (little circled i) the form that opens is the unedited default view. Is there any way I can have the customized View form open when someone clicks the info button?Solved3.3KViews0likes2CommentsExtract text from between characters multiple instances in one cell
Hi I have an online forms database that, when exported, provides both the field label and value, such that many of the table's columns have redundant data. I would like to eliminate the duplicated info. Example: I would like column A to go from: GMC (GMC), NH4+ (NH4+), NO3- (NO3-), Other (Other) to GMC, NH4+, NO3-, Other I tried =MID(LEFT(A1,FIND(")",A1)-1),FIND("(",A1)+1,LEN(A1)) but that returns only the first instance of text bordered by brackets, and I need every instance output into in a single cell.4.2KViews0likes1Comment
Recent Blog Articles
No content to show