Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

How to Construct a Formula: If Cell is Blank Return Value from Another Cell on Same Row

Just Jean
Just Jean ✭✭
edited 12/09/19 in Archived 2017 Posts

How is the formula written to do the following?


If the cell called "Description" on row 1 is blank, use the contents of the cell called "Keywords" on row 1.



  • Mike Andreas

    =IF(Description1 = "", Keywords1, Description1)


    Results in the following - row 1 is the scenario you asked about.  Row 2 is the alternative scenario.



  • Just Jean

    I think I didn't describe the problem correctly. If the cell Description1 is empty/blank then use the value from Keywords1 in cell Description1.


    Thanks for your help Mike.

  • Just Jean

    This seems to work:



    Does that look right?

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Just Jean,



    Your formula does not do anything (useful)


    If your Keywords1 cell is blank, then the result is a blank.

    If it is not, the result is whatever is in Keywords1.


    That is the same as




    Back to the restate problem - you can not have a formula that may be / will be overwritten manually. You also can not self-reference (that is called a circular reference).


    If this formula was located in Description1




    you will get an error.

    If it was allowed, then as soon as someone typed something into Description1, the formula would be lost. 

    Unless you have some means to ensure new rows are alwyas populated with the formula, the new row will just be blank (no formula, no Keywords1)


    Your best best is to have Description1 be the results of the formula and another column to hold the manual entries.







  • Just Jean
    Just Jean ✭✭
    edited 02/27/17

    I see. The user should enter something into Description1, but if they fail to do so, then info in Keywords1 should be used to populate the Description1 cell and =Keywords1 will do just that. Thank you.

This discussion has been closed.