Formula not displaying percentage

I would like to display the most recent data from a cell in the metadata section of my Status Tracker sheet. Every week someone will manually update this information by adding a new date and then manually entering the percentage complete. All of the information at the to pulls in the most recent update in all of the cells on that sheet. When I pull in the percentage from within the sheet it displays as a decimal. I tried updating the cell type to percentage and it does not change.

Is there something I need to update in the formula to do that?

=IFERROR(INDEX(COLLECT([% Complete]:[% Complete], Summary:Summary, 0, [Last Status]:[Last Status], 1), 1), "No Status Updates Recorded") + ""

Find more posts tagged with

Formulas

Accepted answers

All comments

Zachary Hall

Do you need to use this value elsewhere? The easiest would be to have this convert the value to a string instead. You could do it with the following adaptation to your formula:

=IFERROR(INDEX(COLLECT([% Complete]:[% Complete], Summary:Summary, 0, [Last Status]:[Last Status], 1), 1)*100+"%", "No Status Updates Recorded")

I hope this helps!

Nick Korna

Is that + "" section actually in the cell/formula?

This is what will stop it displaying as a percentage.

BethWork

@Zachary Hall

That worked perfectly! I appreciate your help.

@Nick Korna

It was not, but the response before yours helped me edit that formula to include that percentage and it worked. I'm not entirely sure I would understand how to make that edit myself in the future though. As in, what is that actually telling me in a breakdown?

Zachary Hall

Technically both the +"" and what it outputs if there is an error were turning a cell with a number value into a string. When you change the cell to a string it loses the percentage formatting. The easiest in this case was just to commit to calculate the percentage add the percent punctuation as part of the string conversion.

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.