How do I +20

I have a column labeled - "year updated"

In the first cell under it I put 2020 from a drop down menu

In the next column over and in the cell next to it I want to apply (year updated column cell 1) the (2020) cell

and add 20 to that 2020. I have the other column I am trying to populate set up as text/number.

So when I applied it will have read the 2020 and added 20 to it and the cell will now have 2040 in it.

Any suggestions on how to accomplish this would be greatly appreciated!

Thank you so much!


  • Kimberly Loveless
    Kimberly Loveless ✭✭✭✭✭✭

    you would use the formula below where the "Year Updated" is that first column

    =[Year Updated]@row+20

  • Thank you so much for responding! I tried your suggestion and it either gives 2020 with 20 under it in the new cell or it just puts in a 20 in the new cell or #unparseable.

    Do you think its because the 2020 is in a cell that is a dropdown?

    Thank you again for any suggestions you might have to offer!

  • The formula =[Year Updated]@row+20 should work I just tried it even if it is a drop down. But make sure it is a single value drop down if it is Multi Select Drop down it will not calculate right and gives you 2020 20. Also make sure the new column property is a text/number and make sure that in your formula you type in the field name exactly as it is named, you will know this because as you type the formula and type in the field [year updated] it will show you the field you are referencing. Hope this helps!

    Donna Allen

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!