Lock or Store Date/Value Solution without using Zapier

Andrée Starå

Hi @Krystal Garcia

I hope you're well and safe!

Yes, the other way would be to use the Premium App, Bridge, the Smartsheet API, or a 3rd-party service like Zapier.

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Krystal Garcia

@Andrée Starå How can I get support in a demo/set up with Smartsheet API?

Celvin Klassen

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

I want to lock or store data / value solution without using Zapier.

PeggyLang

@Andrée Starå

@Krystal Garcia

I would also like to learn about Smartsheet API. Can you direct me?

Krystal Garcia

@PeggyLang I didn't get any direction on this sorry Peggy

Andrée Starå

Hi @PeggyLang & @Krystal Garcia

I hope you're well and safe!

@Krystal Garcia I missed your reply.

Here's more information.

https://developers.smartsheet.com/

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Celvin Klassen

I hope you're well and safe!

I didn't see your post.

I'd be happy to share an example. 

Please email me at andree@workbold.com, and I'll share it with you.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

ParveenShahul

Hi, could you please share your example with me also - looking for a solution for the exact same issue? Sending you an email now..TIA

Julie Becker

Hi @Andrée Starå , i have sent you an email (per your responses to others here) for your assistance on this topic and look forward to hearing back from you

Shawn Hill

@Andrée Starå - this solution looks like it will work beautifully but, when I try to pull in the date/timestamp from the modified field in the helper sheet using index/match, I'm getting an "#INVALID COLUMN TYPE" error. This resolves when I choose "Date" as the field type, but I need both the date and the timestamp. Any recommendations?