
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,121 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.
262 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
255 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.
227 Views

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