Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
How to match and automate dates?
If I have two tasks and want the due date from one to trigger and match a start date from the next what do I do?
For example: Task 1 has a start date of 8/20/23 and a due date of 8/29/23, when the due date is put in or changed I want the start date of Task 2 to match (also be 8/29/23).
I have tried some =IF functions and watched some videos but am still struggling. Any suggestions?
Thank you!!!
Answers
-
In the Cell you are looking to insert the formula, try =DATEONLY and select the Cell of the due date. Does that work?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!