Conditional Formatting with dates

appe1473

I am trying to figure out how to set a conditional format in smartsheet with dates.

Given one row with cells A, B, and C which are all dates (or blank):

Set Cell A to = Cell B, if Cell C = <blank> [that is, copy content of cell B into cell A]

If Cell C is not blank, then Cell A = Cell C [that is, copy content of cell C into cell A and ignore content of cell B]

The dates themselves to not matter, just whether a date has been entered or not.

Is there a way to do this?? All help appreciated!

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Try this in [ Column A]:

=IF([Column C]@row <> "", [Column C]@row, [Column B]@row)

appe1473

Perfection, thank you!!

Paul Newcome

Happy to help. 👍️

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.