Is there a formula to indicate the change in status direction if updated in a given time?

I want to indicate with up/down arrows in a separate column, if the RYG status for a line item has changed direction in the last X days. e.g. if status went from Red to Yellow, Red to Green, Yellow to Green in the last 30 days - show an upward arrow; if status went from Green to Yellow, Yellow to Red, or Green to Red in the last 30 days- show a downward arrow symbol. is that possible?

Thanks,

Rick

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul H

You would have to setup a second sheet to collect the history, then cross refence that sheet to see what the last entry was.

Here are two examples of something similar

https://community.smartsheet.com/discussion/89984/notification-when-a-task-has-been-re-assigned

https://community.smartsheet.com/discussion/89681/can-i-consolidate-a-weekly-single-cell-update-to-another-cell-to-keep-history-viewable

Andrée Starå

Hi @Rick_Bailey

I hope you're well and safe!

This might help.

Please have a look at my post below with a method I developed.

More info:

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

Would that work/help?

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

Rick_Bailey

Thanks @Paul H and @Andrée Starå !

Andrée Starå

@Rick_Bailey

Happy to help!

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with 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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.