Getting a date when the status cell changed to a certain symbol

Record a date automation has been set up, which is fine for lines going forward, but what about the older lines?

I want to set a date column where it looks at a row, where that row is a tick symbol, give me the date that it changed to the tick symbol

The information is there in the cell history, but I can't link to the cell history and pull what I need out of it

Does anyone know of a way? (Ideally not using helper sheets etc.)

Kind Regards

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

Hi @Jack Cooper

I hope you're well and safe!

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

A possible workaround/solution could be the Smartsheet API, but not sure.

Is that an option?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Jack Cooper

Hi @Andrée Starå

Thanks for getting back to me so quickly!!

I'm well thanks, I hope you are as well

I'll raise an improvement ticket

Kind Regards

Andrée Starå

@Jack Cooper

Excellent!

You're more than welcome!

Yes, I'm well and glad to hear that you are too.

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.