Creating IF AND THEN statement

Lisa VanDine

Hello 

I need help with creating if and then statement to perform the following. 

If Recruited From = Referral 

And

Store Start / Transfer Date = Date

Then

Store Start / Transfer Date +90 days

Here's the code I have and it's giving unparsable. 

=IF (AND([Recruited From]147 = "Referral", [Store Start / Transfer Date]147= DATE, [Referral Fee Due}147= (+90)))

Robert S.

Hello Lisa,

 

Thanks for the question. You can check to see if a column has a date using the ISDATE() function. More on this function can be found here (https://help.smartsheet.com/function/isdate). Here's an example of what this formula could look like:

 

=IF(AND([Recruited From]147 = "Referral", ISDATE([Store Start / Transfer Date]147)), [Store Start / Transfer Date]147 + 90)

 

This formula can be placed in the "Referral Fee Due" column to show the date 90 days after the date in the "Store Start / Transfer Date" column, only in the  condition that "Recruited From" column says Referral AND there is any date in the "Store Start / Transfer Date" column. If either one of these conditions isn't met, it will remain blank. You can find out more about all of the functions used in this help center article (https://help.smartsheet.com/functions).