Sum of column values that come from function formula

I have created a formulation of a drop down with prices associated with each selection that population on a different column:

=IF([Repairs Needed]@row = "Tuck Point", "125", IF([Repairs Needed]@row = "Tuck Point Panel", "450", IF([Repairs Needed]@row = "Tuck Point Column", "150", IF([Repairs Needed]@row = "Tuck Point Major Column", "225", IF([Repairs Needed]@row = "Repair", "200", IF([Repairs Needed]@row = "Repair Panel", "225", IF([Repairs Needed]@row = "Repair Column", "125", IF([Repairs Needed]@row = "Repair Major Column", "450", IF([Repairs Needed]@row = "Replace Panel", "950", IF([Repairs Needed]@row = "Replace Column", "550", IF([Repairs Needed]@row = "Replace Major Column", "1125", IF([Repairs Needed]@row = "Mow Strip", "350", IF([Repairs Needed]@row = "Soldier Course", "125", IF([Repairs Needed]@row = "Rowlock Course", "150"))))))))))))))

But now when I try to sum up the column with my values after selection has been made I get "0"

I'm using =SUM([WO Value of Repairs]3:[WO Value of Repairs]1105)

What am I doing wrong, can it be because some rows don't have a selection?

Screenshot 2023-05-17 112357.jpg

Find more posts tagged with

Construction

Sharing and Collaboration

Support

Solution Center

Project Management

Accepted answers

All comments

Kelly P.

@Victorugo Contreras

Hello Victorugo,

If you remove the quotes from the values, it should work (e.g., use 125 instead of "125"). With the quotes, the values are text; without the quotes, they will be numbers.

Hope this helps!

Victorugo Contreras

You are a life saver @Kelly P. !!!! Thank you so much!!

Kelly P.

@Victorugo Contreras

You are very welcome! 😊

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.