How to update dates to a new future date

admin58441
edited 12/09/19 in Formulas and Functions

Hi I use smartsheet as payroll check system. 

I normally maintain a group name, pay date, direct credit date.

For some groups we pay weekly and for some we pay fortnightly. 

How do i automate date column with future date once i complete the payroll on certain date.

Example

Group Name        Payroll preparion Date             Direct Credit Date

Alfa                       22/07/2019                                22/07/2019               - This payroll is completed

 

Future Payroll

Group Name        Payroll preparion Date             Direct Credit Date

Alfa                       29/07/2019                                29/07/2019               - Future payroll Date.

( this should be automated)

 

Can some one help please.

 

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!