Introduction
In this webinar Rebecca Carruthers, Talis Support Consultant, talks about areas to look at when you're reviewing your digitisation processes, and individual requests. We also take another look at how to mash up your TADC usage reports to get a complete picture on your requests, which is useful information when reviewing your rollover policies.
Recording
Formulas used in the mash-up usage report demonstrated in this webinar:
=IFERROR(VLOOKUP({cell to be matched},{cell range to look in for this and following data},{column number to pull data from},FALSE),)
- eg.
=IFERROR(VLOOKUP('all-requests-2019-06-18'!A2,'views-2019-06-18 90 days'!A:E,5,FALSE),)
- eg.
=IF(SUM(range to review)>0,"YES","NO")
- eg.
=IF(SUM(AA2:AC2)>0,"YES","NO")
0 Comments