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.
=IF formula ???
Comments
-
What are the conditions for the third cell? When do you want it to appear. Do you want it change color based on the date? Please give us more detail to help us understand what you are trying to accomplish in the final cell.
-
Hello Mike,
Thank you for your assistance. I've answered your questions below, I hope it is clear. I've also attached a picture of how I want it to look.
1. What are the conditions for the third cell? Contact every 15 days from "Last Contacted" date
2.When do you want it to appear? "Contact" should appear after the 15 days are up
3. Do you want it change color based on the date? Yes, after the 15 days are up the Action box should read "Contact" (the entire box should be red with the word "Contact" in it)
-
thank you, I got it to work
-
=IF(TODAY() - [Date of Next Contact]1 >= 15, "Contact", "Contacted")
You could change "contacted" to any other message or delete the word and leave the quotation marks to just have the cell blank.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.3K Get Help
- 392 Global Discussions
- 213 Industry Talk
- 447 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives