Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Mon, 06 May 2024 02:23:07 +0000
Post From: Spreadsheet study formula is not saving
| [2015-02-21 17:09:26] |
| User48557 - Posts: 138 |
|
I use this formula =IF(AND(WEEKDAY(A3)=1,A4-INT(A4)<TIMEVALUE("17:00:00"),A3-INT(A3)>=TIMEVALUE("17:00:00")),B3,K4) for 10 different markets on 10 different charts on my watch list. Originally I only had this formula for 5 markets. Then i added it to 5 more markets it worked just fine for the time being. Then i saved and closed my platform . The next day I opened up my platform and the 5 different spreadsheets that i newly added , did not save the formula i added in cell block K3. I attached a image of what happens when i open up my charts. I re-added the formula then saved the platform and closed it down. I've done this numerous times i've even created new spreadsheets in hope that they would save. Every time the same thing happens. The original 5 work fine and the new 5 pop up blank in cell block K3 and the spreadsheets open above my charts. |
ss.GIF