I have a formula that works on one cell but I cannot apply it as a column formula. Need help.

=IF(HAS([Product Training Type Requested]@row , "Tourlock- 1 Day"), 1, 0) + IF(HAS([Product Training Type Requested]@row , "Turnlock- 0.5 Day"), 0.5, 0) + IF(HAS([Product Training Type Requested]@row , "Circlelock- 1 Day"), 1, 0) + IF(HAS([Product Training Type Requested]@row , "Lifeline- 0.5 Day"), 0.5, 0)

Find more posts tagged with

Accepted answers

Paul Newcome

Ok. Give this a try:

=IF([Product Training Type Requested]@row <> "", IF(HAS([Product Training Type Requested]@row, "Tourlock- 1 Day"), 1, 0) + IF(HAS([Product Training Type Requested]@row, "Turnlock- 0.5 Day"), 0.5, 0) + IF(HAS([Product Training Type Requested]@row, "Circlelock- 1 Day"), 1, 0) + IF(HAS([Product Training Type Requested]@row, "Lifeline- 0.5 Day"), 0.5, 0)

If that still isn't quite what you are expecting, what is the exact logic you are wanting to use?

All comments

Paul Newcome

What exactly are you wanting your formula to accomplish?

mpn07

I am trying to create a request form that will see the items in the [Product Training Type Requested] column and auto populate a set amount of man hours into [Training Days Required] and finally, use [Training Days Required] to set [Training End Date]. My goal is to have my team submit a training request using only the Start Date and Product training type and we will be able to see the amount of days required and populate a calendar using the start and end dates.

Paul Newcome

Ok. Give this a try:

If that still isn't quite what you are expecting, what is the exact logic you are wanting to use?

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.