How to update dates to a new future date

admin58441

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.

 

 

Andrée Starå

Hi,

There are a few ways to set it up. Here's two.

1. Template set up for multiple Payrolls and structured with a defined pattern (every seven days, each month) 
2. Using a third-party integration like Zapier and automatically create a new row based on the former one with the correct dates.

Would any of those options work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting