1 of 1 people found this helpful
1. We cannot use function in dashboard text box. it just like notepad only.
create sheet and do all the things what you want.
2. First create banner and then right click the dashboard tab and duplicates sheet /copy sheet and then paste it and then drag the sheets want to add each dashboard.
for 2nd point, instead of creating a dashboard from scratch, create a duplicate copy of it, and then remove the worksheets, Not only would the banner stay the same, u can also maintain the size and position integrity by first placing the new sheets, setting the size and then deleting the old ones.