Best practice of recording occurrences

Hello - apologies if this has been covered elsewhere, I've tried to search for the answer but can't find anything which may work for my purposes.

Ultimately, it may not be achievable, but I thought I'd ask:

I am creating a group of sheets for a team I work with, and they're dealing with recruitment of individuals (inwards and outwards). I'm looking for the best way (by this, I mean easiest way to record, update and track) to allow the team to update the number of organisations with which they share a person's CV.

We would like to track how many CVs have been shared, whilst been able to see at a glance which organisations an individual's CV has been shared with. I've got a large database-type sheet with each row representing a different individual, so ideally it'd be built into that as a column, but I appreciate it may not be achievable.

Any ideas?

Find more posts tagged with

Forms

Human Resources

Sheets

Formulas

Reports

Comments

Shaine Greenwood

Hi Colin,

I'm not exactly sure what you're wanting to see in the sheet, how CVs are connected to the sheet, or how they're being shared, but you may need to get your team to manually enter the organization names in to a Text/Number column.

Colin G

Hi Shaine,

Apologies, upon reading back I definitely could have been clearer with what I wanted to achieve!

The CVs are shared off smartsheets, but I'd like to record - in smartsheets - how many CVs have been shared and with which organisations, so perhaps through a webform, but whatever is as painless as possible. If a person manually enters the CVs into a text/number column, there's presumably no way of automatically calculating how many different lines there are in that cell (and therefore how many CVs have been shared)?

I'm sorry, I'm still half asleep so this probably makes no sense either! Basically, the easiest way of recording, online, a number of occurrences of something that is done offline. I'm aware there will be some element of user-input required, so it's trying to figure out the process which involves the least amount of work for all involved.