Question

Updating Smartsheet Date Column with new value when adding new row

  • 27 March 2022
  • 5 replies
  • 365 views

Userlevel 1

Hi,

I am creating a new row in Smartsheet based on a trigger that is functioning properly.

What I would like to do is this:

Update the NEW row with a date that is 14 days from the updated row’s date.

For example: When the updated row has a date column that says 03/18/2022, the NEW row I am adding should say 04/01/2022.

I have tried searching for answers with no success (probably just bad search terms).

I appreciate any help.


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Userlevel 3
Badge +4

Hey there @SSuser! Maybe formatter would be a good step to implement after adding a new row? I’m not sure if you have tried this yet or not but please update this thread if you do! Best of luck 🙂

Userlevel 7
Badge +14

Hi @SSuser 

Good question.

Check out this help article if the field is a Date/Time field type:

 

Otherwise, you can use this Zapier action step: Formatter > Date / Time > Add/Subtract Time

Userlevel 3
Badge +4

Hey @SSuser, just checking in to see if you were able to implement any of these solutions and if your issue resolved?

Userlevel 1

Thank you both...the formatter did the trick for me!

Userlevel 7
Badge +9

Yay! So glad to hear it, @SSuser! Thanks for sharing what worked for you with the Community. 🤗