Comments
-
Thank you Genevieve. My code was attempting to change the Sheet name, which works as long as it is not a shared sheet. You are right, this is the same in the UI, I am not able to update the name of the sheet even with Admin level access to that Sheet. Thank you for the info.
-
Thanks Paul, it is working. I think it's the same idea you had here. I passed a new empty cell with nothing but the Predecessor column Id and that works nicely. Thank you very much.
-
Hi Paul, I tried all scenarios you suggested but nothing worked. Tested blank rowId, it didn't work, since it needs to be numeric. Tested using the current rowId, this didn't work, it returns a circular dependency which resulted in the same #REF. Tested blank type, this didn't work, it failed with the following error…
-
Hi Paul, I believe rowId needs to be a number, but I'm ok with trying, I'll also try blank type, since I haven't try that yet. Thanks.