How to update Due date?

[amufaamo]

I set Due date for each project with the formula below

IF(HOUR(DATE([End]) - TODAY())/24 <= 0, 0, HOUR(DATE([End]) - TODAY())/24)

It works, but the due date does not update.

So, is there any way to re-calculate the formula?

[diogolupcosta]

Try 000:00:00 and not 0

[diogolupcosta]

And put it on a virtual column

[Suvrutt_Gurjar · Accepted solution]

It sounds you are using real columns to store the remaining days.  Real columns update when record is opened in edit mode or through actions.

You could try one of the below options.

1. If so, you may want to try with virtual columns instead. 

https://help.appsheet.com/en/articles/919891-virtual-columns

2. Depending on your subscription plan you may evaluate using scheduled BOT to change the real columns.

3. If you have handful of projects and if you are willing to use actions, you could use say reference actions to change the real column values with manual action invoking once every day. 

[amufaamo]

Thank you so much. I changed to virtual column, and it worked!!