Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Can any expert let me know if smartsheet is smart enough to provide number of days from a date column and Status column which is a text column showing several text options. When someone change the status from the drop down menu for example forwarded, cancelled and completed etc, is there any formula that can work to give result in number of days as soon as status changes say today. Again one is DATE column and other is TEXT/NUMBER column.