Event Countdown timer

[Mina_O]

Trying to create a countdown timer to add to my event details page.
Try as I might I can’t figure out the formula that would spit out ‘Weeks, Days, Hours, Minutes, Seconds’ based on a given day. Lets use 4th of July (7/4/2019) as the sample event date.

Attempting to create without a table aka a free form formula if that matters but I can use a table if necessary as well.

Appreciate the input!
Bit of a newb.

P.S. I read a similar/ older post here but it does not address my issue or provide a solution.

[Jean_Pierre_Traets]

Dear @Mina_O

Does the below post make sense.

Hourly timesheet

I’m actually working on a time tracking doc for myself right now. My basic approach is as follows. Two main tables: tasks and time entries. Time entries are each linked to a task and have a start and end time. I also have a “time entries” column on Tasks that contains all the time entries associated with that task. A start timer button column on the tasks table creates a time entry and links it to the task. Sets start time to Now(). It leaves the end time blank but a “calculated end time” col…

Credits to @jerols

[Mina_O]

Thanks @Jean_Pierre_Traets for the share! It’s a bit on the complex side though. Hope Coda team can implement a simple feature for this.
I just need a simple countdown timer or formulae

[mallika]

@Mina_O

Have you tried using EventDate-Now()

[Nick_J]

@Mina_O

Try this. In the doc enter

=Date(2019, 7, 4)-Now()

[Mina_O]

Thanks @mallika that was it. Not sure how I missed that

[Mina_O]

Thanks very much @Nick_J!!