How to run a formula if a cell has specific value

I'm new to the Smartsheet community and need some assistance on a formula.

Goal: If cell = 5, then run the formula; if not, then leave blank. The logic appears straightforward, but I'm not getting the correct return.

Formats: Column New Rate D is formatted to number, New Rate 3 and the cell I want the formula to run in are formatted as 'Date'.

=SUMIF([New Rate D]@row = "5", DATE(YEAR([New Rate 3]@row + [New Rate D]@row, MONTH([New Rate 3]@row, DAY([New Rate 3]@row, "1")))))

Find more posts tagged with

Accepted answers

All comments

Heather Duff

Hi @Kim Bowie,

Try this:

=if([New Rate D]@row = 5, DATE(YEAR([New Rate 3]@row)+[New Rate D]@row, MONTH([New rate 3]@row), day([new rate 3]@row)),"")

This translates to:

If New Rate D is equal to 5 in this row, calculate the New Rate 3 date in this row plus the number of years listed in New Rate D. If New Rate D does not equal 5, leave the cell blank.

I wasn't certain where the "1" came in...but hopefully this will do the trick for you. Let me know if it works.

Best,

Heather

kim b

It worked. Thank you so much!!

Heather Duff

Fantastic! Glad it worked.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.