You are welcome. Thank you for sharing your valuable feedback. Please share more details to the use of Due Date in Recruitment Pipeline chart/Project and the expected output to support@indzara.com to assist further. Best wishes.
Are you able to add multiple worksheet tabs for other positions? It seems if you do, the summary fields are still only calculating the original worksheet even if renamed. (interviews, applications, etc)
Thank you for showing interest in our template. Our premium version of the template will help you track multiple position recruitment process at the same sheet. Following is the link to the template for your reference: indzara.com/product/hr-excel-templates/recruitment-manager-excel-template/ Best wishes.
Hello, how can you freeze these graphs on top. I tried to freeze the rows where it's at but the graphs automatically go down. Would appreciate your help.
Thank you for showing interest in our template. Click any once cell from A11 or A12 or A13... then select freeze pans from the view ribbon to freeze the rows above the selected cell including the graph. Best wishes.
The mentioned behavior is expected when you freeze the row between the chart or if the frozen rows are above the chart. You need to ensure the rows are frozen till the last row and last column occupied by the chart. Please share your sheet at the below link to check further: support.indzara.com/support/tickets/new Best wishes.
You are welcome and we regret the inconvenience caused. Please share the copy of the template with some sample data at the below link to assist further. support.indzara.com/support/tickets/new Best wishes.
The tutorial is very helpful except that i am using google spreadsheet which doesn't have the same options as excel in MS Office. Also I am unable to correct the formula used in STAGE column. I keep getting formula parsing error, which I am unable to figure out. Need help!
Thank you for watching our video and sharing your valuable feedback. You can make a copy of the Google Sheet version of Recruitment Tracker template from the link below to review the formulas and modify it in your sheet accordingly: indzara.com/2020/01/recruitment-tracker-for-google-sheets-free/ Best wishes.
Thank you for sharing your valuable feedback. You can share your sheet to support@indzara.com with some screenshot highlighting your concern/doubt/requirement to check further. Best wishes.
Thank you for watching our video. Yes, you will get only one result from the COUNTIF formula. We then click select the cell with formula and double click the dot on the bottom right of the formula cell to fill the same in the rest of the rows. You can also click the dot and drag down to duplicate to new rows or you can also select the formula cell and more cell and press CTRL+D to duplicate the formula. If this is not your concern, please share your sheet to support@indzara.com with some screenshot highlighting your concern to assist further. Best wishes.
Hello, What if I want to do this for multiple vacancies? I do not want to have lots of different spreadsheets for each role, is there a way to have different Sheets at the bottom connected to the Help sheet? (does this make sense?)
Thank you for showing interest in our template. Our premium version of the template will allow you to track multiple positions in the same template. Following is the link to the template for quick reference: indzara.com/product/hr-templates/recruitment-manager-excel-template/ Best wishes.
Thank you for showing interest in our template. You can purchase our premium version of the template available at the below link for upto 10 stages and advance reports: indzara.com/product/recruitment-manager-excel-template/ Best wishes.
at 2:44 into the video you lost me. I've tried that formula several times. rewatched the tutorial and cannot figure out what i am doing wrong for the life of me
Thank you for watching our video. On 2:44, we are selecting the cell B4 which holds the stage 1's name as APPLICATION in HELP sheet. If you are still facing issues, please share your sheet to support@indzara.com along with some screenshot highlighting your concern to check further. Best wishes.
![Excel For HR: How to Use Pivot Tables [2023]](http://i.ytimg.com/vi/uUQlNHHCcF0/mqdefault.jpg)
Your videos are very helpful! Thank you!
Really very good video. Just had a doubt. I wanted to understand that why have you selected the stage column at 2:32 ?
Thank you for sharing your valuable feedback.
It is used to count the number of Candidates in Application stage.
Best wishes.
Hello, thank you for your very impressive work. I would like to ask if how to include the due date for each project column to this spreadsheet
You are welcome. Thank you for sharing your valuable feedback.
Please share more details to the use of Due Date in Recruitment Pipeline chart/Project and the expected output to support@indzara.com to assist further.
Best wishes.
Are you able to add multiple worksheet tabs for other positions? It seems if you do, the summary fields are still only calculating the original worksheet even if renamed. (interviews, applications, etc)
Thank you for showing interest in our template.
Our premium version of the template will help you track multiple position recruitment process at the same sheet. Following is the link to the template for your reference:
indzara.com/product/hr-excel-templates/recruitment-manager-excel-template/
Best wishes.
Hello, how can you freeze these graphs on top. I tried to freeze the rows where it's at but the graphs automatically go down. Would appreciate your help.
Thank you for showing interest in our template.
Click any once cell from A11 or A12 or A13... then select freeze pans from the view ribbon to freeze the rows above the selected cell including the graph.
Best wishes.
@@indzara does that work in sheets? When I tried to freeze a row the graphs jump below the frozen rows
The mentioned behavior is expected when you freeze the row between the chart or if the frozen rows are above the chart. You need to ensure the rows are frozen till the last row and last column occupied by the chart.
Please share your sheet at the below link to check further:
support.indzara.com/support/tickets/new
Best wishes.
hello. Thank you for your video. I keep getting a 0 for the application active count total?
You are welcome and we regret the inconvenience caused.
Please share the copy of the template with some sample data at the below link to assist further.
support.indzara.com/support/tickets/new
Best wishes.
The tutorial is very helpful except that i am using google spreadsheet which doesn't have the same options as excel in MS Office. Also I am unable to correct the formula used in STAGE column. I keep getting formula parsing error, which I am unable to figure out. Need help!
Thank you for watching our video and sharing your valuable feedback.
You can make a copy of the Google Sheet version of Recruitment Tracker template from the link below to review the formulas and modify it in your sheet accordingly:
indzara.com/2020/01/recruitment-tracker-for-google-sheets-free/
Best wishes.
Have some doubt on Recruitment dashboard as it very catchy and impressive would like to do the replica .can you guide
Thank you for sharing your valuable feedback.
You can share your sheet to support@indzara.com with some screenshot highlighting your concern/doubt/requirement to check further.
Best wishes.
Hi for some reason the 2:44 part. Is only populating one result lol. I’m giving up after a hour
Thank you for watching our video.
Yes, you will get only one result from the COUNTIF formula. We then click select the cell with formula and double click the dot on the bottom right of the formula cell to fill the same in the rest of the rows. You can also click the dot and drag down to duplicate to new rows or you can also select the formula cell and more cell and press CTRL+D to duplicate the formula.
If this is not your concern, please share your sheet to support@indzara.com with some screenshot highlighting your concern to assist further.
Best wishes.
Hello, What if I want to do this for multiple vacancies? I do not want to have lots of different spreadsheets for each role, is there a way to have different Sheets at the bottom connected to the Help sheet? (does this make sense?)
Thank you for showing interest in our template.
Our premium version of the template will allow you to track multiple positions in the same template. Following is the link to the template for quick reference:
indzara.com/product/hr-templates/recruitment-manager-excel-template/
Best wishes.
sir what if I have 6 stages? how to formulate please help! thanks
Thank you for showing interest in our template.
You can purchase our premium version of the template available at the below link for upto 10 stages and advance reports:
indzara.com/product/recruitment-manager-excel-template/
Best wishes.
at 2:44 into the video you lost me. I've tried that formula several times. rewatched the tutorial and cannot figure out what i am doing wrong for the life of me
Thank you for watching our video.
On 2:44, we are selecting the cell B4 which holds the stage 1's name as APPLICATION in HELP sheet. If you are still facing issues, please share your sheet to support@indzara.com along with some screenshot highlighting your concern to check further.
Best wishes.
Good tutorial
Thank you.
Best wishes.
I keep getting a 0 for the application active count total?
Please email file to contact@indzara.com and specify the question.
Best wishes.