# IF AND formulas

✭✭✭✭
edited 12/09/19

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:

• ✭✭✭✭

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!