IF, OR, Populate Statement
Hello everyone, not sure if this one is possible, but I'll give it a go. I want to create one formula that basically functions as below:
IF([3MO Left Target Amputation]@row="Yes", Insert Date from [3MO Maj Amputation Left Date]@row),IF([3MO Right Target Amputation]@row="Yes", Insert Date from [3MO Maj Amputation Right Date]@row)
Any help would be greatly appreciated!
Answers
-
Would there only be one or the other option? You would never have both dates selected right? A left and a right?
=IF([3MO Left Target Amputation]@row="Yes", [3MO Maj Amputation Left Date]@row, IF([3MO Right Target Amputation]@row="Yes", [3MO Maj Amputation Right Date]@row))
You pretty much wrote it out correctly, except you closed the first if statement with an ending parenthesis but it should have been nested. And just referencing the column you want to populate the date from, will populate that column's information.
Did it work?
-
Correct, there would never be BOTH dates, just one or the other. I tried entering the formula as I have above and I receive the UNPARSEABLE error. Am I missing something between the left and right parts?
-
Check the column header names. Are they exactly right? can you share a screenshot of the headers with any sensitive data blurred out?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!