#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# Formula help...

Options
✭✭✭✭✭✭
edited 12/09/19

I've tried a formula that seems to work, in that it doesn't give me the lovely "Unparseable" or "Missing Operator" message.

Here's the scenario:
If Column A (text column) contains "These words" then Column D (date column) = Column B (date column).

Column A does contains the needed words, and Column B is a date. But Column D isn't populating the date - it's just blank.

Is Column D not allowed to be a Date column type? I need it to be, but having this formula would reduce the chances of someone forgetting to populate the date into both columns. I have to have the "These words" qualifier.

Blessings,

Loann

• ✭✭✭✭✭✭
Options

Here's how my formula looks:

=IF([Column A)]1 = "These words", [Column D]1)

• ✭✭✭✭✭✭
Options

Based on your description, isn't this (in Column D) what you want?

=IF([Column A)]1 = "These words", [Column B]1)

In Column D, this will set D to B if A matches your text.

Column D is where the calc is.

Hope that helps.

Craig

• ✭✭✭✭✭✭
Options

Craig,

I looked at my formula again, and I believe that's what I actually have.

Real life formula is this:

=IF([Title (Book or Broadcast Title; note HC's)]202 = "Pre-tape", [Taping Date]202)

If our Title column has the words "pre-tape" then I want the Pre-tape date column (column d in above scenario) to equal that of the Taping Date column (Column B from scenario),

But it's not populating the date from one date column to another date column.

• ✭✭✭✭✭✭
edited 03/03/16
Options

Ah.

Two problems.

1. You are using an exact match "="

2. If you wanted an exact match, it is case sensitive "Pre-Tape" is not equal to "Pre-tape"

Try this:

=IF(Find("Pre-Tape",[Title (Book or Broadcast Title; note HC's)]202)>0, [Taping Date]202)

In case I typed that wrong, here's the psuedo code

=IF(FIND("text to find", cell) > 0, "gotit")

Craig

• ✭✭✭✭✭✭
Options

And watch out of #2.

You can get rid of some errors by

FIND("pre-tape",LOWER(cell))

but that won't catch things like "PreTape" or other misspellings.

Craig

• ✭✭✭✭✭✭
edited 03/04/16
Options

It's working! I used the "Find" option, Craig. Thank you so much.

This discussion has been closed.