CountDown Timer

[Sinethemba_Gayi]

Hi, Does AppSheet have a Countdown feature? Would be useful in Project Management

[Aleksi]

What kind of countdown feature are you looking for?

[Sinethemba_Gayi]

I am working on the Construction Daily Report App and would like to include a feature or column with “Days to completion” where it days will deplete based on the scheduled completion date

[Aleksi]

Okay… then add a virtual column for your counter like [CompletionDate]-TODAY(). It will count it every time when you sync the app.

[Sinethemba_Gayi]

If I hear you correctly:

1. I must create a column called “Completion Date” on the Date format,
2. Then create a column “Days to completion” - set this as Virtual Column with App Formula “CompletionDate - TODAY()”

Question - What format must the Virtual column be on?

[Aleksi]

The result is a number.

[Sinethemba_Gayi]

1. If a set the Virtual Column formula to Number I get this error message: “Column Name ‘Days To Completion’ in Schema ‘Job_Schema’ of Column Type ‘Number’ has an invalid app formula ‘=[Completion Date] - TODAY()’. The type of the app formula ‘Duration’ does not match the column type 'Number”

2. If a set the Virtual Column formula to Duration I get a result of “4704:00:00”

In both instances, I created a spreadsheet column and typed in a Completion Date (same name as column name) of 11/25/2019.

I then created a Virtual Column with App Formula: [Completion Date] - TODAY(). which gives me the above results.

[Aleksi]

My typo error… HOUR([Completion Date]-TODAY())/24