Hello,
I'm hoping somone has some insights on this one ( @CarlosFigueira, @Shanescows, @mrdang ? 🙂 ). I'm seriously stuck!
Sets Year: Set(thisYear,Text(Today(),"[$-en-US]yyyy"));
Sets Half:
If(Text(Today(),"[$-en-US]mm")="01",
Text(Today(),"[$-en-US]mm")="02",
Text(Today(),"[$-en-US]mm")="03",
Text(Today(),"[$-en-US]mm")="04",
Text(Today(),"[$-en-US]mm")="05",
Text(Today(),"[$-en-US]mm")="06",
Set(thisHalf,"1"),"2");
Sets Month: Set(thisMonth,Text(Today(),"[$-en-US]mm"))
I can't seem to figure out the combination of Sort/Filter/Lookup needed to display the [compX_num] in the label. Any leads would be SO much appreciated. I'm about 3 days into trying different things!
Thank you
If you would like to filter the record together with Year and half, then the Lookup formula should be written in this way:
Lookup(ListName,
and(cost_center=ThisItem.cost_center,
thisYear=ThisItem.year,
thisHalf=ThisItem.half)).comp1_num
For the Fill property, could you please explain a bit for the
"evaluated this year, half, and month" condition?
Basically, the color change mostly depends on the If condition.
The logic for the fill property should be:
If (ConditionMet, color1, color2)
For example, for this Year color:
If (thisYear=ThisItem.year, color.azure, color.white)
Regards,
Michael
Hello @v-micsh-msft,
Thank you for looking further into this. The "year", "half", and "month" fields were of the Sharepoint Calculated-type. This was causing problems. Once I replaced them with Single Line of Text columns and handled the variables in the app, I was able to get the Lookups to work.
User | Count |
---|---|
247 | |
103 | |
82 | |
49 | |
43 |