IF formula to generate deadline

Kristen Helmers

Hello,

   I am looking to create an IF formula that would generate an upcoming deadline automatically based on two factors.  The first is a customer dropdown selection row and the second being the submission date of the item.

   Such that if a certain customer is selected a due date will be generated 10 days from the submission date.

Kristen Helmers

=IF(AND(Customer1 = "Universal", [Inquiry Type]1 = "Scope Change"), DATE([Requested Date]1 + 10))

 

This is where I am at so far and it doesn't seem to be correct.

 

Any help would be greatly appreciated.

Kristen Helmers

I have also tried this and get an incorrect argument error.

 

=IF(AND(Customer1 = "Universal", [Inquiry Type]1 = "Scope Change", DATE(DAY([Requested Date]1) + 10)))

 

Is this not a possible function in smartsheet

J. Craig Williams

Kristen,

 

Try this:

 

=IF(AND(Customer1 = "Universal", [Inquiry Type]1 = "Scope Change"), [Requested Date]1 + 10, "")

 

1. You did not close the AND() properly.

2. Days can be added to dates directly.

3. This formula should be in a Date type column.

4. The "" makes the date blank if you don't match your criteria. You can skip that without harm.

 

Hope this helps.

Craig

Kristen Helmers

Thank you! This works perfectly!!