yeah source 1 is always going to exist, but if source 2 exist, I would like for the code/formula to disregard the first source and only display  the second.  Hopefully that makes more sense.  Both source fields will live on different forms but at the project level. 

looking to create a calculated field that displays the text from two other calculated fields.  However if both fields exist, default to only display the second field.

Here's my updated code that works: IF({DE:Source Field} < 50,"Less Than 50%","50% Complete").  Need to figure out had to add the project status as a parameter in this field.

this is my current basic code that isn't working to display the text field I want: IF({sourceField} >= 50 AND {sourceField} <= 100, "Yes", "No")

Hi All, I need to create a project level calculated field to display a text message, if the data range falls within a certain range ie between 50-100% display text "Yes" if less than 50% display text "No". I also need to apply  an 'IF' filter in the field that makes sure the field is only working on...

I want to create a column in a task level report that shows the last note on a document that is in the document section of the task. However, I need the note to display with a reference to who posted the note and which document it is associated with (we usually have multiple documents in each task)....

We're creating some custom task level fields that we want to nest on a project level form.  Is this possible or would it be best to attempt to nest this task level fields on a parent task?

In my instance we have a project view that was created by a previous admin that displays the actual day a task has a planned start date (ex. "Monday", or "Tuesday"), however what users have noticed is that day being displayed is often incorrect, usually a day later of so. I did some digging and noti...

Hi All,We have custom user forms attached to each user, that has accurate data pulling in from other platforms.  We want to use this data on the custom form to update native user fields in WF (i.e. telephone, city and state).  How would I go about creating a fusion scenario that uses preexisting dat...

No bueno. @Sven-iX thanks for all your help though.