Assign Today() to 'Start date' when 'Status' changes to 'In Progress'

1

Hi,

In a task table, which has ‘Start date’ and ‘Status’, is there a way to set it up so that it assigns Today() to ‘Start date’ when its ‘Status’ changes to ‘In Progress’ from ‘Not started’?

Jaewon

2

Dear @Jaewon_Jung,

Hopeful the below solves your question:

image

In the column “Start Date” you should put the following IF statement:

If(Status="In Progress",Today(),"")

Meaning: If status = in progress display today’s date if not keep empty.

Kind regards,
Jean Pierre

3

You could also try buttons. This would give you a date of when the button was clicked…

CloudApp

The Start button configuration looks like this:

Start Button Config

start-button-config
start-button-config.png1144×1074 52.8 KB

The Finish button configuration looks like this:

Finish Button Config

finish-button-config
finish-button-config.png1184×988 47.6 KB

4 Likes
4

I guess in that case the ‘Start Date’ will keep changing (for instance to 10/6 the next day) as it remains in ‘In Progress’ state? Which is not what I want.

1 Like
5

You could set up an Automation so that when the value is changed to In Progress, it will update the Start Date. Using that method, your Start Date will remain the same unless someone switches the status to something else, then back to In Progress again.

6

I tried this solution and could not for the life of me get it to actually place a date in the column. Not a big fan of the buttons either.