How can I?

I am trying to create a automatic function whereby reviewing the status of two cells it will be able to show a progress status in the form of arrow symbols

for example if i have :

column 1 status total = 4

Column 2 updated weekly total =6

Column 3 movement progress = automatic appearance of ⬆️ ➡️ ⬇️ symbols.

I am struggling to create the right formula to do is, can anyone help?

thanks

mel

Find more posts tagged with

Accepted answers

Paul Newcome

I would use this symbol column type:

The formula would be...

=IF([Column 2]@row = [Column 1]@row, "Unchanged", IF([Column 2]@row< [Column 1]@row, "Down", "Up"))

All comments

Paul Newcome

What would be the logic for up, right, and down arrows?

Mel C

Hi Paul

I want to Show progress up = forward progress/ Down = backwards progress/ sideways has remained the same.

there may be a better way of showing this so happy for any options really.

thanks

Mel

Paul Newcome

I would use this symbol column type:

The formula would be...

=IF([Column 2]@row = [Column 1]@row, "Unchanged", IF([Column 2]@row< [Column 1]@row, "Down", "Up"))

Mel C

Paul Thank you so much that worked a treat.

kind regards

Mel

Paul Newcome

Happy to help. 👍️

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.