Using text mode to compare 2 columns and populate a customer field with details from a 3rd column

[SimoneFr1]

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:

displayname=Nov Capacity

lF(Planned=Start Date>Requested Launch Date,capacity point rating,"")

querysort=DE:Nov

textmode=true

valuefield=Nov

valueformat=customNumberAsString

Help?

[SarahNa]

Hi Simone -

I can probably help with this - can you give me some more information?

• Is this a project report?
• Is the planned start date of the project or a task?
• Is the field 'Requested Launch Date' a custom field or a task date?
• Is the 'capacity point rating' a custom field? What is the exact name?
• And just to confirm, if the planned start date is after the launch date, you want the field to be blank?

Thanks!