IF, OR, Populate Statement

Options

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

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    edited 03/02/21
    Options

    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?

  • Kayla Whaley
    Options

    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?

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!