How to pass comments from one sheet to Home page

[#1]

Dear all,

We have multiple reports in multiple sheets and have input box in each sheet(report) for user to provide comments which is allowed only when Reviewed mark(text object) is clicked in sheet and then both comments and review status i.e 'Reviewed or Not Reviewed' should be updated in Home page (in a straight table which is having report names as dimension and comments and review status as expressions).

Here, issue is when user provide review status and comments in one sheet/report , those values are being updated in Home page i.e in straight table but they are being updated for all rows(i.e all dimension values) where we expect that updation should happen specific to each sheet.

Please find that attachments and let us know your valuable suggestions.

Thanks in advance.

Regards,

Kishore.

[kaushiknsolanki · Accepted solution]

Hi,

Hope this will solve your problem.

Regards,

Kaushik Solanki

[#3]

Perfect.Its working fine.

Thanks a lot Kaushik. Your quick response is much appreciated.

[kaushiknsolanki]

Great

Regards,

Kaushik Solanki

[#5]

Hi Kaushik,

Can you please provide the suggestion on below thread.

How to pass comments from multiple sheets to Home page specific to month wise

Thanks in advance.