Help on how to insert a formula based on another cell criteria

I want to create a simple subtraction formula that will only be added to the cell if another cell is one of two text responses. I know I could do the subtraction as a column formula very easily but most cells in the column don't meet the need for this formula so come back as Unparseable which just looks awful.

This is what I have tried

=IF(OR([Refund or New Date]@row=”Refund”, ”New Course”),THEN([Created]@row-[Date of Course]@row)

=IF([Refund or New Date]@row, ISTEXT, value_if_true, [Created]@row-[Date of Course]@row)

We have a refund and rebooking policy and to make it easier for the admin staff to know if the request meets the criteria (i.e has been requested in time) I want to subtract the dates automatically.

Help please?

Find more posts tagged with

Formulas

Accepted answers

All comments

Protonsponge

Hello @Lorri Rose

If I read correctly, are you looking to subtract [Created] minus [Date of Course] if [Refund or New Date] equals either " Refund" or "New Course"? If so the following may be helpful to you:-

=IF(OR([Refund or New Date]@row = "Refund", [Refund or New Date]@row = "New Course"), Created@row - [Date of Course]@row, "")

I hope that is helpful to you in someway,

Protonsponge

Lorri Rose

Oh that seems to work perfectly - thank you so much!

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.