We did not use any macros and I tried this on open document triggers but we are using Ajax and we checked in access point. This document triggers not working..and we have a single sheet based dashboards..so sheet level triggers also not working.
Gopi, could you use a Let statement on a variable in the Script that would update on each load and then where you need that set, use the variable in the expression?
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.