Is it possible to have the arrow marks as shown in the screenshot below? Like, it should not be a fixed one, it should be dynamic. If yes how this is achievable?
@aishabhy05, Write the formula for the text format line item with emojis, using IF and ELSE statements for different emojis.
IF Salary < 50000 THEN "π»" & "Low Salary" ELSE "β¬οΈ" & " High Salary"
Try this formula:
If (Percent Line Item * 100) < 0 THEN "π»" & TEXT(Percent Line Item * 100) & "%" ELSE "β¬οΈ" & TEXT(Percent Line Item * 100) & "%"
To improve on this, create a list for each Salary Band and put the text there; then use a list formatted line item for display, not text. Also, there's no need to be doing the text concatenation hereβ¦
Thanks @MarkWarren and @Dikshant .
Is it it possible to have % and the text line item together (with symbols)? output : π»-1 % β¦ β¬οΈ 5% @Dikshant @MarkWarren
You have to convert the number format line item into text using TEXT function and then do the concatenation
Example:
If Percent Line Item < 0 THEN "π»" & TEXT(Percent Line Item) ELSE "β¬οΈ" & TEXT(Percent Line Item)
Thanks @Dikshant I already tried, however I'm not getting % it is showing me something like this .. I want the exact % to be captured.. like β¬ 0.1% β¦.
There was an error rendering this rich post.
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context andβ¦
