Hi Forum,
I a building a spreadsheet for work, to help manage and track our mailbox, were I have a list of multiple employee types (column c), Date received (COLUMN D), date replied (Column e), people who responded back to them (Column G), response status (h), what the question pertains to (I), who is responsible for it (J) and if it will be added to an FAQ (K), tagged as (Column M)
Only one of my employee types, "checking box" needs the rest of the columns to select the specific items fro their lists.
The ones Id want toautopopulate are:
·Column D: Date received: date info is being entered - auto populate
oOption to override this if necessary but default to datebeing entered
·Column E: Date replied/closed: copy info in column D
·H: Response Complete: no response necessary (selected from the response list on the other tab)
·I: Question pertains to: No action needed (Selecte from list)
·J: Respond Individually: N/A (from list)
·K: Add to reorg: N/A (from list)
·M: Tagged as: no action needed (from list)
I a building a spreadsheet for work, to help manage and track our mailbox, were I have a list of multiple employee types (column c), Date received (COLUMN D), date replied (Column e), people who responded back to them (Column G), response status (h), what the question pertains to (I), who is responsible for it (J) and if it will be added to an FAQ (K), tagged as (Column M)
Only one of my employee types, "checking box" needs the rest of the columns to select the specific items fro their lists.
The ones Id want toautopopulate are:
·Column D: Date received: date info is being entered - auto populate
oOption to override this if necessary but default to datebeing entered
·Column E: Date replied/closed: copy info in column D
·H: Response Complete: no response necessary (selected from the response list on the other tab)
·I: Question pertains to: No action needed (Selecte from list)
·J: Respond Individually: N/A (from list)
·K: Add to reorg: N/A (from list)
·M: Tagged as: no action needed (from list)
