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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives