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
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)))
Comments
-
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).
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives