replace text for tab to tab sheet to sheet

Started by jebuxx, June 10, 2015, 06:31:19 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

jebuxx

June 10, 2015, 06:31:19 PM
Hello, Here's the problem. I have 5 popup error messages on tab 4 (sheets 12,13,14,15) that are triggered when entries are made on tab 1 that create a diagram. Each with it's own rules and are visable only when the rules are in error.
I am trying to have a sheet on tab 1 (sheet 28) that will notify that there are error messages on tab 4 that should be reviewed. I know how to just duplicate the error messages to tab 1 but that would be an eye sore. I would like sheet 28 to simply say "Errors on tab 4 MUST be reviewed"
The formulas for the error rules are very lengthy as you could imagine so rewriting them in a formula to activate the message sheet on tab 1 will not
be an easy task.
Help here would be truly apperciated.
Print
Go Up Pages1
User actions
Browser ID: smf (is_webkit)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 125 (show)
Files included: 34 - 1317KB. (show)
Memory used: 1076KB.
Tokens: post-login.
Cache hits: 12: 0.00188s for 26,582 bytes (show)
Cache misses: 1: (show)
Queries used: 15.

[Show Queries]