BEECN Journaling System Back-end: Difference between revisions
From Portland NET Wiki
mNo edit summary |
|||
| 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)'' | ||
