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

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

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

Tags:

Comments

  • Robert S.
    Robert S. Employee
    Options

    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.