Adding a date

Options

BlakeView

BlakeView ✭

11/16/22 in Formulas and Functions

I am trying to add a date to a cell when that row is added.

I have a row moving from another sheet, when it goes to the new sheet I would like it to record the date it was moved

0 ·

Answers

Samuel Mueller Overachievers

11/16/22
Options
You can use the automation "Record a date" and the trigger on both sheets is new row added.

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

Formula to flag overdue tasks
I've got a formula that flags overdue tasks, but it flags every task with no date. Is there a way to omit nulls? =IF(Status@row <> "Complete", IF(Finish@row > TODAY(), 0, 1))
Help with a Formula?
Hi, I am working on row of dates and I am trying to get the next due date (from today) in another column. I have tried a couple of formulas but get #UNPARSEABLE. What should the formula be? I am looking for the formula for the cell in yellow.
CountIF Formula with Criteria
I have a formula to count how many stores an owner has in our system. It is working great: =COUNTIF([Primary Contact (Company) (Company)]:[Primary Contact (Company) (Company)], [Primary Contact (Company) (Company)]@row) (You can see John Voskamp has 91 stores). I need to determine of the store count, how many are "Open".…