BEECN Journaling System Back-end: Difference between revisions
From Portland NET Wiki
| (One intermediate revision by the same user not shown) | |||
| Line 19: | Line 19: | ||
===Volunteer information (color coded light orange)=== | ===Volunteer information (color coded light orange)=== | ||
#'''Vol: Coordinator''' <span style="background:firebrick; color:firebrick">'''_'''</span><span style="background:firebrick; color:white">'''''locked'''''</span><span style="background:firebrick; color:firebrick">'''_'''</span> - Provides the name of the Coordinator for that BEECN crew. Vacancies appear highlighted in bright orange. This column pulls data from sheet "3.) BEECN Volunteers" and the individual cells cannot be changed. When volunteer records need updating, that should '''''ALWAYS''''' be done in the BEECN Volunteers Sheet. <span style="background:yellow">Formula is:</span> ''=IFERROR(INDEX({VolSscontactX}, MATCH([*Vol: CoordID]@row, {VolTypeID}, 0), 1), "Vacant")'' | #'''Vol: Coordinator''' <span style="background:firebrick; color:firebrick">'''_'''</span><span style="background:firebrick; color:white">'''''locked'''''</span><span style="background:firebrick; color:firebrick">'''_'''</span> - Provides the name of the Coordinator for that BEECN crew. Vacancies appear highlighted in bright orange. This column pulls data from sheet "3.) BEECN Volunteers" and the individual cells cannot be changed. When volunteer records need updating, that should '''''ALWAYS''''' be done in the BEECN Volunteers Sheet. <span style="background:yellow">Formula is:</span> ''=IFERROR(INDEX({VolSscontactX}, MATCH([*Vol: CoordID]@row, {VolTypeID}, 0), 1), "Vacant").'' EXAMPLE: <u>=IFERROR(INDEX({'''C: BEECN Volunteers;''' Smartsheet Style Contact''}, MATCH('''''A.) BEECN Master Tracker'''; type of coordinator...coordinator or assistant coordinator@row''', {C: BEECN Volunteers;''' type of coordinator}, 0),1), if nothing there display "Vacant".</u> | ||
#'''Vol: Asst Coordinator''' <span style="background:firebrick; color:firebrick">'''_'''</span><span style="background:firebrick; color:white">'''''locked'''''</span><span style="background:firebrick; color:firebrick">'''_'''</span> - Provides the name of the Assistant Coordinator for that BEECN crew. Vacancies appear highlighted in bright orange. This column pulls data from sheet "3.) BEECN Volunteers" and the individual cells cannot be changed. When volunteer records need updating, that should '''''ALWAYS''''' be done in the BEECN Volunteers Sheet. <span style="background:yellow">Formula is:</span> ''=IFERROR(INDEX({VolSscontactX}, MATCH([*Vol: AsstCoordID]@row, {VolTypeID}, 0), 1), "Vacant")'' | #'''Vol: Asst Coordinator''' <span style="background:firebrick; color:firebrick">'''_'''</span><span style="background:firebrick; color:white">'''''locked'''''</span><span style="background:firebrick; color:firebrick">'''_'''</span> - Provides the name of the Assistant Coordinator for that BEECN crew. Vacancies appear highlighted in bright orange. This column pulls data from sheet "3.) BEECN Volunteers" and the individual cells cannot be changed. When volunteer records need updating, that should '''''ALWAYS''''' be done in the BEECN Volunteers Sheet. <span style="background:yellow">Formula is:</span> ''=IFERROR(INDEX({VolSscontactX}, MATCH([*Vol: AsstCoordID]@row, {VolTypeID}, 0), 1), "Vacant")'' | ||
#'''Vol: Assigned''' <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 BEECN volunteers assigned to that resource, as summed from "3.) BEECN Volunteers". <span style="background:yellow">Formula is:</span> ''=COUNTIF({VolNameX}, [Resource Name]@row)'' | #'''Vol: Assigned''' <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 BEECN volunteers assigned to that resource, as summed from "3.) BEECN Volunteers". <span style="background:yellow">Formula is:</span> ''=COUNTIF({VolNameX}, [Resource Name]@row)'' | ||
| Line 184: | Line 184: | ||
{{#ev:vimeo|811015364|350|inline|'''''Video: Adding a BEECN Volunteer in SmartSheet'''''|frame}} | {{#ev:vimeo|811015364|350|inline|'''''Video: Adding a BEECN Volunteer in SmartSheet'''''|frame}} | ||
===== Q: I don't see a | ===== Q: I don't see a Maintenance Ticket I was notified about. Where do I find it? ===== | ||
===== Q: What steps should I take if a cache is stolen? ===== | ===== Q: What steps should I take if a cache is stolen? ===== | ||
