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.

Formula for capturing the date when the status column change

Yovanka Barnard

Yovanka Barnard ✭

01/25/17 edited 12/09/19 in Archived 2017 Posts

Hi,

I have a completion date column.

I want to know if there is a formula I can capture in the date column to indicate that specific date when the Status was changed to complete?

Please help.

Yovanka

Tags:

0 ·

Comments

J. Craig Williams ✭✭✭✭✭✭

01/25/17

See this post (by me)

http://ronin-global.com/2016/12/11/smartsheet-fixed-date-upon-completion/

Craig

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Action item Tracker with 2 way sync for selective items
I would like to manager a Master Action Item Tracker, but there are some items on the list that are confidential. Is there a way for me to create a duplicate of that action tracker for selective rows and for my team and I to colloborate on updating status between the Master and duplicate tracker and have the updates feed…
Need help with a cross-sheet reference formula.
I am trying to create a cross-sheet formula so I can count the number of projects for a specific PM where the show start data is in the month of January and year is 2024. The source sheet contains show start dates that are in 2025 so I want to be able to avoid counting them by mistake. I'm basically trying to count the…
Auto Number Formula Help - Add Project Code as Prefix
Hello, Is there a way to create an auto-number system to show [Project Code]-P-[AutoNum] where the auto number references the project code in the same row? Here's an example to illustrate: But when I try to add this prefix system to the Auto Number column properties… [Project Code]-P- types it literally… "[Project…