Formula for impact score x likelihood

Hi i currently have the below formula but need help amending this

=IF([Impact Score]@row = "", "", [Impact Score]@row * [Likelihood Score]@row

I need to amend this for if column type is risk then impact score* likelihood score and if column type is issue then return impact score only

Thanks

Find more posts tagged with

Formulas

IF(OR

IF(AND

IF(

if formula

Accepted answers

All comments

There are no accepted answers yet

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.