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
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.
Comments

=IF(Description1 = "", Keywords1, Description1)
Results in the following  row 1 is the scenario you asked about. Row 2 is the alternative scenario.

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.

This seems to work:
=IF(ISBLANK(Keywords1),"",Keywords1)
Does that look right?

Just Jean,
No,
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
=Keywords1
Back to the restate problem  you can not have a formula that may be / will be overwritten manually. You also can not selfreference (that is called a circular reference).
If this formula was located in Description1
=IF(ISBLANK(Description1),"",Keywords1)
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.
Craig

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.