nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Stacked "IF" statement only pulling in some values

KayZee_2025

Hello,

I'm trying to pull in values across several the "Helper" columns below into the "EOY Forecast" column using a stacked "IF" statement:

=IF(NOT(ISBLANK([Construction Helper]@row)), [Construction Helper]@row, IF(ISBLANK([Construction Helper]@row), [Late Helper]@row, IF(ISBLANK([Late Helper]@row), [Mid Helper]@row, IF(ISBLANK([Mid Helper]@row), [Early Helper]@row))))

I want the formula to pull in the column values from rightmost to leftmost, as they are chronological project stage advancements.

The formula works perfectly until it gets to the Mid and Early columns and then doesn't pull a value in. Does anyone have any suggestions what I might be doing incorrectly? Thanks!

Trova più post etichettati come

Accepted answers

All comments

Paul Newcome

Give this a try:

=IF([Construction Helper]@row <> "", [Construction Helper]@row, IF([Late Helper]@row <> "", [Late Helper]@row, IF([Mid Helper]@row <> "", [Mid Helper]@row, [Early Helper]@row)))

KayZee_2025

Paul Newcome

@KayZee_2025 Im' not sure what happend with your latest comment, but all I see is a yellow exclamation point.

KayZee_2025

https://community.smartsheet.com/discussion/comment/513458#Comment_513458

Strange - sorry about that. Your solution worked - thank you very much!

Paul Newcome

Ah. Ok. Happy to help. 👍️

Sign in to join the conversation!

Link veloci

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.