我有一个谷歌表，我用它来索引属性列表，与应用程序脚本设置编辑创建一个属性子文件夹内的草案文件夹使用的值在A和B列时，'草案'是在C列选定。
即参考+位置
我目前正在尝试让脚本移动属性子文件夹之间的'草稿文件夹'，'活文件夹'，'存档文件夹'取决于列C中的列表状态.（这些文件夹存在于一个主要的父文件夹，我想避免手动移动属性子文件夹之间的草稿，活和存档.
然而，我遇到了问题，在属性子文件夹不移动方面。文件夹ID是正确的，文件夹名称完全匹配，但当我选择“实时”或“存档”在C列，属性子文件夹不从草稿移动到选择文件夹，什么也没有发生。
有谁能告诉我哪里出错了，以及如何在C列移动选择的属性文件夹？
应用程序脚本很简单，它检查文件夹是否已经存在，如果不存在，则在草稿中创建子文件夹，ELSE检查文件夹是否需要移动。

以下是要将属性子文件夹移动到的设置文件夹的ELSE IF

} else if ((status == 'Live' && statusFoldername != 'Live Folder') || (status == 'Archived' && statusFoldername != 'Archive Folder')) {
    
                if (statusFoldername != 'Live Folder') {
                    var moveToFolder = liveFolder;
                } else {
                    var moveToFolder = archveFolder;
                }
                propertyFolder.moveTo(moveToFolder);
            }

以下是完整版本。

function createFolderSubFolders(e) {
    // Get Parent folder
    var parentFolder = DriveApp.getFolderById('ID');
    var draftFolder = DriveApp.getFolderById('ID');
    var liveFolder = DriveApp.getFolderById('ID');
    var archveFolder = DriveApp.getFolderById('ID');

    // Get current spreadsheet
    var ss = SpreadsheetApp.openById('ID');
    var i = e.range.getRow();

    // Process if Col B is not empty and Col C equals 'Draft'

    if(ss.getRange('C' + i).getValue() == 'Draft') {
        
    //Set intended folder name
        var ref = ss.getRange('A' + i).getDisplayValue();
        var location = ss.getRange('B' + i).getValue();
        var status = ss.getRange('C' + i).getValue();
        var propertyFolderName = ref + ' - ' + location;
        
    ///Check if folder already exists
        var findTest = false;
        //Get FolderIterator for looking into status folders
        var statusFolders = parentFolder.getFolders();
        // Checks if Parent Folder already has Folder with given name
        while (statusFolders.hasNext() && findTest == false) {
            var statusFolder = statusFolders.next();
            //Property Listings in current iterated status folder.
            var propertyFolders = statusFolder.getFolders();
            while (propertyFolders.hasNext() && findTest == false) {
                var propertyFolder = propertyFolders.next();

                if (propertyFolderName == propertyFolder.getName()) {
                    //Check where property folder lies currently.
                    var statusFoldername = statusFolder.getName();
                    findTest = true;
                    break;
                }
            }
        }
        // Create new property folder in draftFolder if not already created.
        if (findTest == false) {

            var propertyFolder = draftFolder.createFolder(propertyFolderName);

            //Otherwise check if folder needs to be moved to other section.
        
    } else if ((status == 'Live' && statusFoldername != 'Live Folder') || (status == 'Archived' && statusFoldername != 'Archive Folder')) {

**//Set folder where to move the propertyFolder
            if (statusFoldername != 'Live Folder') {
                var moveToFolder = liveFolder;
            } else {
                var moveToFolder = archveFolder;
            }
            propertyFolder.moveTo(moveToFolder);
        }**
    }
}