Using the Realvolve Reporting Add-on
The Realvolve Reporting add-on pulls data from the Realvolve Property and Transaction databases to build custom reports.
Sample Spreadsheet Document
Click HERE to view a spreadsheet containing sample reporting sheets used with the data gathered by the Realvolve Reporting Add-on. Some modifications will need to be made to accurately represent your data.
NOTE: You will need to make a copy of this master spreadsheet in order to use it.
Installing the Realvolve Reporting Add-on
(Google Sheets)
Installing the Realvolve Reporting Add-on
(Direct Link)
Click HERE to install the Realvolve Reporting Add-on for Google Sheets
Helpful Formulas/Features in Google Sheets
- UNIQUE - https://support.google.com/docs/answer/10522653
- QUERY - https://support.google.com/docs/answer/3093343
- COUNT - https://support.google.com/docs/answer/3093620
- COUNTIFS - https://support.google.com/docs/answer/3256550
- SUM - https://support.google.com/docs/answer/3093669
- SUMIFS - https://support.google.com/docs/answer/3238496
- AVERAGE - https://support.google.com/docs/answer/3093615
- AVERAGEIFS - https://support.google.com/docs/answer/3256534
- MIN - https://support.google.com/docs/answer/3094017
- MAX - https://support.google.com/docs/answer/3094013
- FILTER - https://support.google.com/docs/answer/3093197
- LOOKUP - https://support.google.com/docs/answer/3256570
- VLOOKUP - https://support.google.com/docs/answer/3093318
- HLOOKUP - https://support.google.com/docs/answer/3093375
- ARRAY - https://support.google.com/docs/answer/6208276
- ARRAYFORMULA - https://support.google.com/docs/answer/3093275
- ARRAY_CONSTRAIN - https://support.google.com/docs/answer/3267036
- SORT - https://support.google.com/docs/answer/3093150
- Data Validation - https://cloud.google.com/blog/products/g-suite/pro-tip-how-create-dropdown-list-google-sheets-and-pointers-conditional-formatting
- Conditional Formatting - https://support.google.com/docs/answer/78413?co=GENIE.Platform%3DDesktop&hl=en
DOM (Special Lookup Formula)
The Days On Market column is a calculated cell.
=ArrayFormula(if(W3:W<>"",Iferror(DATEDIF(A3:A,VLOOKUP(W3:W,{'Realvolve Transaction Data'!$T$3:$T,'Realvolve Transaction Data'!$F$3:$F},2,False),"D"),"-"),if(A3:A<>"",Iferror(DATEDIF(A3:A,TODAY(),"D"),"-"),"")))
The above formula looks to see if there is a value in the column W (Transaction Id) and does a lookup of column T (Transaction Id) in the Realvolve Transaction Data for the data in the W (Transaction Id) of the Realvolve Property Data to find a match and return the value in the F (Closing Date) column of the Transaction Data and calculates the number of days difference (DATEDIF) between that and Column A (Listing Date) of the Property Data. If the cell is blank in column W (Transaction Id) then the calculation is based on the number of days from the listing date to the current date since there is no transaction to link to.