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

Options

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
Options
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

Formula Functionality: RYGB Status Change Based on Date
Hello! I have reviewed Smartsheet Discussions quite a bit, but this is my first post. I am trying to correct a formula I made to change RYGB statuses. Currently the status correctly changes based on the following: Blue if a Date Resolved is entered. Green if the # of calendar days is > or = to 15 days. Yellow if the # of…
Simple Workflow Not Triggering
Hi, I have a very simple workflow set up using "TODAY()" date as a formula. Basically it's a tracker with due dates, and if a particular task is not "Complete" by the due date, the status will change to "Overdue". Let me emphasis that there are no external links on this sheet and the formulas work fine. The workflow is as…
Alerts when X ammounts of items arrive for project X
Backround: I work with custom computers, its only me myself and i in my department so i am looking to automate as much as possible. I have a sheet where i enter every part that arrives and which Project number it belongs to, what Serial number the part has and the parts EAN code. Goal: I would love if i could set up a…