Expand my Community achievements bar.

MATTHEW450
MATTHEW450
Offline
Type
  • All
  • Questions
  • Discussions
  • Ideas
  • Blogs
Filter by user contributions
  • I would say that your CONCAT({plannedCompletionDate}) is unnecessary, you can just use {plannedCompletionDate}. For the color, you can't format just a single item on the list, it will always format every item on the list. If you are isolating a single task on the list, then you can create two separa...

    Type

    Discussions

    Views

    1.4K

    Likes

    0

    Replies

    1
  • I've used an expression like this with a collection column to Isolate a particular task from a list   valueexpression=IF(CONTAINS('First Word',{name})=true,IF(CONTAINS('Second Word',{name})=true,IF(CONTAINS('Third Word',{name})=true,CONCAT("Condensed Task Name - ",{plannedCompletionDate})," ")," "),...

    Type

    Questions

    Views

    253

    Likes

    0

    Replies

    0
  • I don't think this is possible. Using conditional formatting will always format everything within a column. To isolate elements you need to wrap elements in HTML using spacing columns. But when it comes to a collection, you cannot wrap individual elements because they can't be isolated

    Type

    Questions

    Views

    389

    Like

    1

    Replies

    1
  • You won't be able to isolate the word "Delivered" with a list unfortunately, you would end up formatting the entire list. But if you did want to isolate a word, it would look something like this: column.1.valueexpression=IF(ISBLANK({actualCompletionDate})," ",{actualCompletionDate}) column.1.value=H...

    Type

    Discussions

    Views

    1.5K

    Likes

    0

    Replies

    3
  • Is it possible to add a background color to a cell using HTML instead of conditional formatting? I would prefer using HTML when concatenating a bunch of cells together rather than add conditional formatting to a field I hope is always there. Thanks!

    Type

    Questions

    Views

    229

    Likes

    0

    Replies

    1
  • Could you provide an example? Something I could copy and past and see what you mean. Thank you!

    Type

    Discussions

    Views

    1.7K

    Likes

    0

    Replies

    1
  • So far I am not seeing a limitation on CSS as long as it is inline. Just made some shapes and adjustments   CSS: margin: value; width: value; height: value; margin: value; display: value; align-items: value;

    Type

    Discussions

    Views

    1.7K

    Likes

    0

    Replies

    0
  • To use HTML, you can only use it one way, in a value line   displayname=Circle value=<div style="background: #0000FF; border-radius: 50%; padding: 5px; width: 50px; height: 50px; text-align: center;"><font color=#0F0F0F>Maybe</font><div> valueformat=HTML sharecol=true   To apply it to a field, you n...

    Type

    Discussions

    Views

    1.7K

    Like

    1

    Replies

    5
  • I'm trying to find some master list of compatible HTML/CSS with Workfront reporting. How far can you go? Can you use javascript potentially? I'm going to leave a list of coding I have found and how I use it, if you have anything to add, please leave it below! HTML: <a href:"link here">Click Here</a...

    Type

    Discussions

    Views

    1.7K

    Likes

    8

    Replies

    14
  • I got it to work! Thank you so much for the suggestion. I used your structure, and substituted the "URL" in the "link.url=URL" with link.url=customDataLabelsAsString(Custom Field Name)  and the "URL" in the if is blank statement with my custom field to make it work. I did not need a "DE:" in the "li...

    Type

    Questions

    Views

    369

    Likes

    0

    Replies

    0
Top badges earned by MATTHEW450
Customize the badges you want to showcase on your profile