FORT Tips and Tricks

FORT Tips and Tricks are created based on questions and feedback reported by users. Features of the FORT system as well as how to navigate them will be shared below in detail along with screenshots.

January 2024 Tips and Tricks

• Using the Filter & Sort functions on the Project Summary tab
• Using Excel formulas on the Project Detail tab 

SORTING ON THE PROJECT SUMMARY TAB - Highlight the header row (whether the columns are expanded or not), go to the data tab at the top to open the data ribbon, select ‘filter,’ then choose the column to sort or filter using the drop-down arrow located at the bottom right of that column.

USING EXCEL FORMULAS - Excel formulas can be used in yellow cells and any white cells above or below the project detail table. However, the formulas are not retained once uploaded. Only the value is retained in yellow projection cells, so the result of the formula in a yellow cell will still be there after it has been uploaded.

 Find these tips and more in the Research Administration Newsletter.