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
Check out the Formula Handbook template!