COUNTIF from multiple sheets

Options
Chitta
Chitta ✭✭✭✭
edited 04/27/21 in Formulas and Functions

Hi,

Can someone help me on my below formula please!

Scenario: I have a UATStartdate in multiple sheets and I want to store "Overlap" in my UATOverlap column if UATStartdate clashes with other sheets. I am using below formula in UATOverlap column but getting "UNPARSEABLE" error! Kindly help

=IF(COUNTIF([UAT Start Date]1:[UAT Start Date]14 + COUNTIF({Sheet1}) + COUNTIF({Sheet2}), [UAT Start Date]@row) > 1 "Overlap")

Appreciate any help!

~Chitta

Best Answer

  • Chitta
    Chitta ✭✭✭✭
    Answer ✓
    Options

    I was able to correct and below is the corrected formula which works for me.

    =IF(COUNTIFS([UAT Start Date]1:[UAT Start Date]3, [UAT Start Date]@row) + COUNTIFS({Sheet1}, [UAT Start Date]@row) + COUNTIFS({Sheet2}, [UAT Start Date]@row) > 1, "Overlap")

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    Hi @Chitta 

    Hope you are fine, if it's possible to share me as an admin on a copy of your sheets (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Chitta
    Chitta ✭✭✭✭
    Answer ✓
    Options

    I was able to correct and below is the corrected formula which works for me.

    =IF(COUNTIFS([UAT Start Date]1:[UAT Start Date]3, [UAT Start Date]@row) + COUNTIFS({Sheet1}, [UAT Start Date]@row) + COUNTIFS({Sheet2}, [UAT Start Date]@row) > 1, "Overlap")

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hi @Chitta

    Thanks for posting your solution! 🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!