IF, THAN, ELSE statement

I am needing to create a formula and I am stuck.

I have 3 columns, "PO Cut", "Completion Date" and "Number of days"

What I am tying to do is have the "Number of days" column show how many days have passed since the "PO Cut Date", unless there is a date value in the "Completion Date" column, then just calculate number of days between "PO Cut" and "Completion Date".

Thanks!

Find more posts tagged with

Accepted answers

Antonio Figueroa

=IF([Completion Date]@row = "", TODAY() - [PO Cut]@row, [Completion Date]@row - [PO Cut]@row)

CameronKeel

Thx, Antonio, Not sure what I was missing.

Genevieve P.

Hi @CameronKeel

Yes! You can do this using Conditional Formatting rules.

See: Apply Formatting Automatically with Conditional Formatting Rules

Cheers,

Genevieve

All comments

Antonio Figueroa

=IF([Completion Date]@row = "", TODAY() - [PO Cut]@row, [Completion Date]@row - [PO Cut]@row)

CameronKeel

Thx, Antonio, Not sure what I was missing.

CameronKeel

@Antonio Figueroa is it possible to add if the number is larger than "90" turn the font color red?

Genevieve P.

Hi @CameronKeel

Yes! You can do this using Conditional Formatting rules.

See: Apply Formatting Automatically with Conditional Formatting Rules

Cheers,

Genevieve

Antonio Figueroa

Yes all you need to do is select the column you want to format and click on Conditional Formatting

then add new rule. Next you will see something like this.

click on set condition. Click on the Column you wish to format and then click on define custom criteria.

Open the dropdown menu and select is greater than. in the next box type in the criteria 90 and hit ok.

Next click on this format and pick a color. Next click on entire row if you just want that column to change colors.

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.