IF AND formulas

Options
Dave Godfrey
Dave Godfrey ✭✭✭✭
edited 12/09/19 in Formulas and Functions

I wonder if anyone would be able to help me.

 

I am trying to collate some data that allows me to give a count of a number of jobs that have missed a target date.  The sheet I am working on also has 2 different cost centres and I would like to break this data down so that I can see the data for each cost centre.  I have managed to get the IFAND formals to work for both of the sheets, an example of one is below.

=IF(AND([Purchase Order Issue Date]25 > ([Date Quote Sent to Client]25 + 29), [Purchase Order Issue Date]25 < ([Date Quote Sent to Client]25 + 46)), 2, 0)

I am struggling to add the =IF([Cost Centre]25 = 3444 part of the formula for this to work.

 

Any suggestions would be a massive help.

 

Thanks

Dave

 

Tags:

Comments

  • Dave Godfrey
    Dave Godfrey ✭✭✭✭
    Options

    Hi Everyone,

     

    I have now managed to figure this one out.

    The formula should be

    =IF([Cost Centre]25 = "3444", IF(AND([Purchase Order Issue Date]25 > ([Date Quote Sent to Client]25 + 29), [Purchase Order Issue Date]25 < ([Date Quote Sent to Client]25 + 46)), 2, 0)

     

    Thanks to anyone who has looked at this.

     

    Dave

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!