Archived 2016 Posts
Archived 2016 Posts
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.
Formula help...can this be done?
Column A is a date column. Column B tells us if we have scheduled Column A so it will sort into the right report.
The formula in Column B needs to state that if Column A is a date, then the value is YES; If Column A says "Not Scheduled" it is No. Otherwise, Column B will remain blank.
Can that be done?
Blessings,
Loann
Comments
-
Absolutely! There's a really handy "ISDATE" formula that can help us with this (see http://help.smartsheet.com/articles/775363-using-formulas#logic):
=IF(ISDATE([Column A]1), "YES", IF([Column A]1 = "Not Scheduled", "NO", ""))
Basically, we have two steps:
1) If the value in Column A is any date, set this cell to "YES." Otherwise, go to step 2.
2) If the value in Column A is "Not Scheduled" (capitalization doesn't matter, but spelling does), then set this cell to "NO." If neither of these conditions were met, leave the cell blank.
I hope that addresses your question! Let me know if something needs to be changed.
-
Perfect!! I was so close, but was missing something as I kept getting either Missing Parameter or Unparseable.
Bless you, Greg!!!Loann
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 500 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 78 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Trending Posts
- I am trying to count the number of times "N/A" is included in a single row. I know it can been done with a single range with the below equation, but in this sheet there are some columns that want to e…
- Hello! Long time listener, first time caller — We have a weekly update dashboard that is presented on Thursdays. We'd like to have the date displayed be either the previous weeks Thursday or the curre…
- Hello Team, May be this is intentional, but want to double check. In a sheet, when i open the conversations window, I am able to see tabs for "Row", "Sheet" "All" and "Unread". On the contrary, in a r…