How do I properly use conditional formatting during the import process?

How do I properly use conditional formatting during the import process?

What is conditional formatting?

Conditional formatting is a feature available on most spreadsheet applications (e.g. Microsoft Excel, Google Sheets) that highlights cells based on certain criteria. In this case, we use conditional formatting to make sure that the email address and date of birth fields are being added using the correct format. For example, if you add 'sample@sample' as the email address using the template, it will highlight the cell in red since it is missing '.com' at the end. This will help you identify any erorrs in your file prior to uploading it on Vome!

How do I use the correct paste option?

If you are planning on copying and pasting email addresses or date of birth fields, you need to ensure that you are using the correct paste option, otherwise conditional formatting will not get applied!

Luckily, it is very simple.

Before pasting an email address or date of birth field on the template:

1. Highlight the cells and right click with your mouse

2. Click on the arrow for Paste Special

3. Then click  Merge Conditional Formatting



    • Related Articles

    • How do I prepare my spreadsheet to import into my database?

      First off, it is important to understand that for each import, you can perform Bulk Actions on volunteers listed in the spreadsheet. If you want to assign your volunteer list to different opportunities, tags or shifts during the import process, you ...

    • How do I use a Custom ID field to find and match profiles during the import process?

      *Please note this feature is only available for customers using the Enterprise Plan By default, we find and match profiles using the user's email address. In other words, it is the primary field on Vome. Here is an example to illustrate this. For ...

    • How do I import profile pictures for users in my database?

      Using Vome's import process, you will see that you can import profile images for users in bulk. It is important to note that this feature was designed to help organizations mass import profile images from another software. As such, the way you import ...

    • How do I use Forms on Vome?

      Although you can use forms for surveys or any other data collection purpose from volunteers, they are often used for recruitment. How do people arrive to the form to fill it out and submit their response? There would be 3 ways for volunteers to ...

    • How do I use Sequences on Vome?

      Sequences are used to manage a step by step process. Although it can be used for project management or managing tasks, it is often used for onboarding new applicants. You can completely customize the steps of a sequence, assign profiles and easily ...