Text in a cell dependant on the presence of text in another?
I am a new perspective user of "SmartSheet" I have a scenarario I am trying to complete. I use excel right now, have been for a while. So i will explain like its excel somewhat what I am trying to do.
Cell C1 is formated for a date input column header is "Start Date". Cell D1 is formated for a date input, the column header is "Date Finished". Cell E1 is where i want the result and the formula, the column header is "Status". If C1 has a date present, E1 returns "Started". If D1 has a date present, E1 returns "Complete". If neither C1 or D1 has a date present, then E1 returns "Not Started". I know how to do this in Excel, but I cannot seem to get it to work in SmartSheet?
Answers
-
Hi,
This formula should work for you. Plug it into the first cell of the "Status" Column, then right-click and choose "convert to column formula". Let me know if you're wanting to try anything else.
=IF(AND(ISBLANK([Start Date]@row) = true, ISBLANK([End Date]@row) = true), "Not Started", IF([End Date]@row <> "", "Complete", IF([Start Date]@row <> "", "Started")))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 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
Check out the Formula Handbook template!