I'm creating a report that I'd love to automatically populate one column based on certain dates of a project. Using text mode on a custom field is the best way, but it's not seeming to work. Any chance someone can review and lend me some sanity?
Human way of saying it: If the date in "Planned Start Date" is before the date in "Requested Launch Date", the column "Capacity Points" should be whatever the value is in the column named "Capacity Point Rating"
My if statement for the calculated field:
lF(Planned=Start Date>Requested Launch Date,capacity point rating,"")