I'm trying to extract the Google Drive Folder ID on Google sheets formulas. The issues is there are two type of URL are pasted by different Individuals in the sheet.

With the sharing ? mark at the end