Share via

The Syntax of This Name Isn't Correct

Anonymous
2019-02-27T22:12:35+00:00

I have two tabs with the same column names for both. See the pic below.

This is my formula. It calculates date due based on severity. :

=IF([@Severity] = 3, [@[Date Found]] + 90, IF([@Severity] > 3, [@[Date Found]] + 30, IF([@Severity] < 3, [@[Date Found]] + 180)))

This works on one tab. It doesn't work on the other tab. This is the message I get.

How do I get this to work on the second tab of the same document?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-03-01T19:20:30+00:00

    It's literally just some text in a column. There is nothing there to check. If this program can't interpret basic human input, what good is it?

    6 people found this answer helpful.
    0 comments
  2. Anonymous
    2019-03-02T08:51:07+00:00

    Hi HBU,

    Sorry for the bad user experience. To help you run your formula normally, please copy the formula that you can run normally and paste it into issue related cells then modify cell name to check if you can run it normally.

    If you still can run your formula normally, please share with me your workbook in PrivateMessage to let me help you. Thanks for your understanding.

    Regards,

    Neo

    0 comments
  3. Anonymous
    2019-03-03T11:40:45+00:00

    Hi HBU,

    I haven't received your reply in PM. Can you run your formula normally now? Do you still need any help?

    Regards,

    Neo

    0 comments