
Contributor III
2024-06-27
05:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Create a flag and color cell accordingly
The below is my data in this I want to create a flag
Num | Name | PRAG | CRAG | Value |
1 | ksfhwef | G | R | 183 |
2 | weifjo | R | A | 600 |
3 | weoifkwenm | R | G | 174 |
4 | wef | A | G | 477 |
5 | pocijepw | G | R | 106 |
6 | okjprrg | G | R | 189 |
7 | eproijgp | R | A | 410 |
8 | erpioj | R | G | 546 |
9 | wepoj | A | G | 315 |
10 | we | G | G | 420 |
11 | dmk2f | R | R | 686 |
12 | fvdkjvpeioj | R | G | 684 |
13 | jkbxc u | A | G | 444 |
14 | dfivjeproj | R | R | 537 |
15 | lkdmvor | R | R | 143 |
16 | rewgre | R | G | 271 |
17 | epirjf | G | G | 385 |
18 | erge | G | R | 685 |
19 | lkndvoi | R | R | 431 |
20 | mvb | R | G | 426 |
21 | vlkernlk | R | R | 682 |
22 | ervmer | A | R | 454 |
23 | qefmkpap | G | A | 271 |
24 | kjsendwqed | G | G | 624 |
25 | ekwmdoi | R | G | 614 |
I need to create a flag
CRAG | Direction |
R | Neutral |
G | Up |
A | Up |
G | Up |
R | Down |
A | Neutral |
A | Down |
R | Down |
G | Neutral |
I want the output like this
1,122 Views
- « Previous Replies
-
- 1
- 2
- Next Replies »
12 Replies

Contributor III
2024-07-04
03:26 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks, @Rohan I will Try and Let You Know.
263 Views

Contributor III
2024-07-04
05:04 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Rohan I tried this but the output is not coming as Per My Requirement
As You see the First one A,G Is Up But It came Down
same for all
256 Views

Partner - Specialist
2024-07-04
07:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @BhaminiParmar12 ,
My bad, i missed the order in the applymap :
Applymap('DirectionMap',PRAG&'|'&CRAG,'N/A') as Direction
Let me know if this works.
Regards,
Rohan.
228 Views

- « Previous Replies
-
- 1
- 2
- Next Replies »