Formula to reference one column based on entries from another column.

I need help on a formula for Project Assignment when a dollar amount is what determines who gets a Project assignment.

For example,

A Facilities coordinator will get a project if it falls between $5k - $24,999

Project Manager A will get a project if it falls between $25k and $99,999

Project Manager B will get a project if it falls between $100k and over

My attempt at creating the formula is below

=IF([Estimated Budget]@row = "Estimated Budget is between 5000 and 24999", "blue", IF(Estimated Budget@row = "Estimated Budget is between 25000 and 100000", "green", IF(Estimated Budget@row = "Estimated Budget is greater than 100000", "Pink")))

Find more posts tagged with

Formulas

functionality

Accepted answers

Werner Gerstacker

Try this:

=IF([Estimated Budget]@row >100000, "Pink", IF([Estimated Budget]@row >24999, "Green", IF([Estimated Budget]@row > 4999, "Blue", "Nobody, really?")))

Linda F

It worked, thank you so much !

All comments

Werner Gerstacker

Try this:

=IF([Estimated Budget]@row >100000, "Pink", IF([Estimated Budget]@row >24999, "Green", IF([Estimated Budget]@row > 4999, "Blue", "Nobody, really?")))

Linda F

It worked, thank you so much !

Werner Gerstacker

Glad I could 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.