BEECN Journaling System Back-end: Difference between revisions

===Volunteer information (color coded light orange)===

#'''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)''

{{#ev:vimeo|811015364|350|inline|'''''Video: Adding a BEECN Volunteer in SmartSheet'''''|frame}}

===== Q: What steps should I take if a cache is stolen? =====

# Hit Ctrl-F to open the "Find/Replace with" dialogue box (screenshot labeled "Step 6" below). On the left side, input the old name of the resource. On the right side, input the new name. Then click "Replace All".

# Repeat steps 3 - 6 for the BEECN Volunteers sheet and the BEECN Trouble Tickets sheet.

<gallery perrow="2" widths="400" caption="Screenshots of Steps 3 (l) and 6 (r); click to enlarge.">

File:Step 3- Changing the resource name in the dialogue box..png|alt=Screenshots of Steps 3 (l) and 6 (r)

File:Step 6.png

</gallery>