BEECN Journaling System Back-end: Difference between revisions
From Portland NET Wiki
mNo edit summary |
|||
| Line 43: | Line 43: | ||
#'''Cache: Radio Serial Number''' - The serial number of the handheld UHF radio in the cache. The cell will highlight dark yellow if this data is still needed. | #'''Cache: Radio Serial Number''' - The serial number of the handheld UHF radio in the cache. The cell will highlight dark yellow if this data is still needed. | ||
=== Cache tickets and notes (color coded | === Cache tickets and notes (color coded light purple): === | ||
#'''Tickets: n=active''' ''<span style="background:firebrick; color:firebrick">'''_'''</span><span style="background:firebrick; color:white">'''locked'''</span><span style="background:firebrick; color:firebrick">'''_'''</span>'' - The number of currently active "trouble tickets". This cell will turn dark purple if number of tickets is more than zero. This data is pulled from "4.) BEECN Trouble Tickets". <span style="background:yellow">Formula is:</span> ''=COUNTIFS({TicketsCloseDateX}, ISBLANK(@cell), {TicketsResourceNameX}, [Resource Name]@row)'' | #'''Tickets: n=active''' ''<span style="background:firebrick; color:firebrick">'''_'''</span><span style="background:firebrick; color:white">'''locked'''</span><span style="background:firebrick; color:firebrick">'''_'''</span>'' - The number of currently active "trouble tickets". This cell will turn dark purple if number of tickets is more than zero. This data is pulled from "4.) BEECN Trouble Tickets". <span style="background:yellow">Formula is:</span> ''=COUNTIFS({TicketsCloseDateX}, ISBLANK(@cell), {TicketsResourceNameX}, [Resource Name]@row)'' | ||
#'''Tickets: n=history''' ''<span style="background:firebrick; color:firebrick">'''_'''</span><span style="background:firebrick; color:white">'''locked'''</span><span style="background:firebrick; color:firebrick">'''_'''</span> -'' The number of tickets issued on this resource for all time, including currently active ones. This data is pulled from "4.) BEECN Trouble Tickets". <span style="background:yellow">Formula is:</span> ''=COUNTIF({TicketsResourceNameX}, [Resource Name]@row)'' | #'''Tickets: n=history''' ''<span style="background:firebrick; color:firebrick">'''_'''</span><span style="background:firebrick; color:white">'''locked'''</span><span style="background:firebrick; color:firebrick">'''_'''</span> -'' The number of tickets issued on this resource for all time, including currently active ones. This data is pulled from "4.) BEECN Trouble Tickets". <span style="background:yellow">Formula is:</span> ''=COUNTIF({TicketsResourceNameX}, [Resource Name]@row)'' | ||
