How to update dates to a new future date

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.

Find more posts tagged with

Healthcare

Formulas

Hi,

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

Template set up for multiple Payrolls and structured with a defined pattern (every seven days, each month)
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

Hi Andree,

Thank you for inputs.

Option 1 seems to be lot of manual and let me think about the option 2.

Is there any possibility to update smartsheet automation rules. SS Automation rules also have lots of limitations.

Happy to help!

Option 1 would be more work when setting up the template structure but not ongoing.

Not sure I follow! What do you mean with updating the Smartsheet automation rules? What would you want to happen?

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?