Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

Avatar

Level 1

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?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

0 Replies

Avatar

Level 7

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!