Column Formulas

Hello,

I am putting column formulas on a sheet, which I'm excited about.

However, we had a top row that had some explanations for users i.e. whether a column was Required, Admin only, and this one that has been super helpful to find people what RYGB stand for rather than having them interpret for themselves.

"Status" convention:

Red – Task is off track, without a plan to get back on track

Yellow – Task is off track, with a plan to get back on track

Green – Task is on track

Blue – Task is complete

However, with column formulas, it adds the formula to ALL cells in the column.

I know I can add in under i for a column but it's less easy to see.

Does anyone else use explanations? and how do you do that? Looking for any and all suggestions.

Thank you,

Melitta

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

Hi @Melitta King

You can use something to identify the specific row and then add the description to the formula, but it will only show for the row as needed.

Make sense?

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 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!

Melitta King

Hi Andree,

I understand the concept of what you are saying but I'm struggling to put it together. Any sources or info you can point me to?

Thanks,

Melitta

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.