Hi,
Follow this Dynamic Sheet
- Create a variable vShow with the following value:
=ceil((frac(now())*86400/(vSheets*vDelay)-floor(frac(now())*86400/(vSheets*vDelay)))*(vSheets))
- Create variable vSheets = no of sheets to cycle through (5 in this case)
- Create variable vDelay = time in seconds (30 in your case)
- Finally, set each sheet to conditionally display using the expression
vShow=1 (for the first sheet)
vShow=2 (for the second sheet, and so on)
The vShow variable expression will return the value 1, then after 30 seconds, the value 2 etc, causing the displayed sheet to change every 30 seconds.
