CountDown Timer

AppSheet AppSheet Q&A
1

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

2

What kind of countdown feature are you looking for?

3

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

4

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

1 Like
5

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?

6

The result is a number.

7

  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.

8

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