Fill field with date when condition is met

Fill field with date when condition is met

edited 12/09/19 in Using Smartsheet

Hi,

I have a tracking sheet for status changes on activities. In detail, I'm tracking the status of potential partners being onboarded. So I need to track, when the initial contact is met, when a contract is signed and when they are active. For each stage in their Journey I'm changing the status field, by moving the card from one status to another.

Hence, I'm changing the field "Status" for instance from "initial Contact" to "contract signed".

I'd like to add a new field, which logs the date, when the card has been moved to "contract signed".

Is there a chance to set an automated field, which is dependent on the status of a task / card?

Comments

Sign In or Register to comment.