Sunday, October 12, 2014

yogi_CountDown To Today's Date From Google Form Submission Date

                  Google Spreadsheet   Post  #1790
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Oct-12-2014
post by  Bryan Harstead:
Spreadsheet Countdown
So I made a form that submits some information to a spreadsheet. When this is submitted to the form it gives a timestamp. What I want to be able to do is make a counter that counts from that day to present day. So I used =ROUNDDOWN(MINUS(TODAY(),C2)) but what is happening is when the information is submitted from the form it erases the formula in that row. I also want to change the timestamp to only come up as date and no time.
Alright so I did what you said. The first line is a date 7 days from 10/12 and 2nd line was submitted on 10/12 which the countdown is 0 days since today is the 10/12. I want the count timer to count up to the present day. Every time a form is submitted it erases that formula in that row. Also when there is no data in the that row is has the numbers 41924 boded.