How do I auto populate a date column when another column changes state?

gdooley@jbelectric

gdooley@jbelectric ✭✭✭✭

06/21/23 in Formulas and Functions

When Status1 Changes to Closed I would like to auto populate the date column.

0 ·

Answers

Paul Newcome Community Champion

06/21/23

Have you looked into the Record A Date automation?

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Would you benefit from getting my help in person?
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

IF/AND/OR formula help
I currently have a formula that works that checks the red flag if either of these two situations are present; 1. the end date is prior to the start date; or 2. the end date is more than 4 years from the start date. This is the formula: =IF([Target End Date]@row < [Target Start Date]@row, 1, IF(AND(OR(NETDAYS([Target Start…
Keep Getting Invalid Value for this Formula
Hi, If someone proficient in smartsheet can help me out on this. I keep getting #invalid value for my dates that I enter from January to March. But from April onward the (target submittal dates appear). =IFERROR(DATE(YEAR([Project Start Date Tentative]@row), MONTH([Project Start Date Tentative]@row) - 3, DAY([Project Start…
My formula is not working, for one specific line in my task sheet. why does it not work
This is the formula, I receive Invalid in the cell =IF(AND(MONTH([Start Date]@row) <= 1, MONTH([End Date]@row) >= 1, YEAR([Start Date]@row) <= 2025, YEAR([End Date]@row) >= 2025), 1, 0)