Return 1st column value if 2nd and 3rd column is blank
Hello,
I am trying to come up with a solution for my smartsheet involving 4 columns (4th being the result column). I wanted to return the value from the 1st column whenever 2nd and 3rd column are blank, if not return the value from either 2nd or 3rd column.
These columns contains dates by the way.
Sent (1st) ; Won (2nd) ; Lost (3rd) ; S/W/L Date (Result column)
So I tried the formula independently and it worked ok but when I combined them, i'm getting the "#Invalid Operation" result.
1. If(and(Won=0,Lost=0),Sent - result OK
2. If(isblank(Won),Lost,Won) - result OK
3. IF(AND(Won=0, Lost=0),Sent,IF(ISBLANK(Won),Lost, Won)) - result #Invalid Operation
I've attached a screenshot for a better picture.
Would love to see your kind reply.
Comments
-
Try something along the lines of this...
=IF(ISDATE(Lost@row), Lost@row, IF(ISDATE(Won@row), Won@row, Sent@row))
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives