Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Creating IF AND THEN statement

Lisa VanDine
Lisa VanDine ✭✭
edited 12/09/19 in Archived 2017 Posts


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

If Recruited From = Referral 


Store Start / Transfer Date = Date


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.
    Robert S. Employee

    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).

This discussion has been closed.