Monkey Tools

SmartFolder Monkey

Article Overview One of our favourite tricks is to create a “From Folder” solution which avoids hard-coding a file path, instead pulling it dynamically via our fnGetParameter setup. The issue is that this creates a link to either a local or SharePoint / OneDrive for Business folder. However, this causes problems when you open the file in […]

Smart Folder Function

Article Overview If you save your files into folders that sync to OneDrive for Business or SharePoint, you’ll know the pain that happens if you try to reference a folder based on the path returned by the CELL() function… The SmartFolder function provides the answer to that problem, as you can pass it either a […]