Is there a way to auto populate a cell whenever I enter data in a row?

Is there a way to auto populate a cell whenever I enter data in a row?

For example, let's say I am adding information to columns B and C (no specific order) for row #1, and whenever I provide this information, I would like column A to auto populate with the Study ID (the study ID will be the same for all rows).

Thanks

Best Answer

  • Christian G.
    Christian G. ✭✭✭✭✭✭
    edited 11/07/22 Answer ✓

    Add this formula to the "Study ID" column.

    It checks if either Name or Description is not blank.

    =if(or(not(isblank(Name@row)),not(isblank(Description@row))),"STUDY NUMBER","")

    Just to change "study number" by the number you want.

    I fyou want both column "Name" and "Description" to be filled before showing the Study number, use this formula:

    =if(AND(not(isblank(Name@row)),not(isblank(Description@row))),"STUDY NUMBER","")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!