Feb 18 2022 03:16 AM
Hi Everybody. I have a fairly simple 365 Workbook that is being used in the D\Top App, I am working on the file locally and all is fine. However when I copy it to another OneDrive location I get problems with the formula I am using to insert the worksheet name into a specific cell. The problem formula is :-
=IF(ISERROR(RIGHT(@CELL("filename",$A$1),LEN(@CELL("filename",$A$1))-FIND("]",@CELL("filename",$A$1)))),"This workbook never saved",RIGHT(@CELL("filename",$A$1),LEN(@CELL("filename",$A$1))-FIND("]",@CELL("filename",$A$1))))
TIA
Jon
Feb 18 2022 03:31 AM - edited Feb 18 2022 03:31 AM
Solution@JonnieMorgan Tried to replicate what you described and encounter no problems. By the way, you can shorten the formula by using IFERROR rather then combining IF and ISERROR.
=IFERROR(RIGHT(@CELL("filename",$A$1),LEN(@CELL("filename",$A$1))-FIND("]",@CELL("filename",$A$1))),"This workbook never saved")
Feb 18 2022 03:42 AM
Feb 18 2022 04:16 AM
Feb 18 2022 03:31 AM - edited Feb 18 2022 03:31 AM
Solution@JonnieMorgan Tried to replicate what you described and encounter no problems. By the way, you can shorten the formula by using IFERROR rather then combining IF and ISERROR.
=IFERROR(RIGHT(@CELL("filename",$A$1),LEN(@CELL("filename",$A$1))-FIND("]",@CELL("filename",$A$1))),"This workbook never saved")