Click here to Skip to main content
14,366,152 members
Rate this:
Please Sign up or sign in to vote.
I would like to have the cell (column D) next to column F update to a dropdown list of the sitemap URLs based off the link next to the cell labeled "Staging Link" when column E is updated to "Open". This sheet will have multiple links so the logic will need to loop up to find the nearest staging link above the row being edited. My script linked from this is still pretty far off but was my starting point to work from. Thanks for any help!


1.) User updates column E to "1-Open"
2.) Script: Loops up to find nearest value of "Staging Link" above cell being edited
3.) Script looks up XML sitemap of URL next to cell "Staging Link"
4.) Script adds list Data Validation to Column D adjecent to cell that was originally edited. Data Validation is drop down list of URLS in sitemap from staging link.

What I have tried:

Google Sheets link

Google Apps Script link
Updated 17-Jul-18 20:16pm

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100