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.

Autofill Stopped Working

edited 12/09/19 in Archived 2016 Posts



I'm have 2 autofill fields on a basic sheet which was working up until yesterday afternoon , and now for some strange reason one of them has stopped working, and I'm also unable to add a new column with an identical formula.


Sheet Columns:


Likelihood - Number 1-5

Impact - Number 1-5

Level - Formula =IF(OR(ISBLANK(Likelihood1), ISBLANK(Impact1), "", Likelihood1* Impact1)

Rating - Forumla =IF(Level1 >= 15, "High", IF(Level1 >= 9, "Medium", IF(Level1 < 9, "Low")))


The formula for Level works fine and autopopulates when a new row is added

The forumal for Rating works if dragged down but doesn't autopulate if a new row is added and Likelihood & Rating are completed.


This is especially an issue if populating through web form or AppSheet.


Any ideas why it's no longer work.


Thanks !


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



    How are you adding new rows? You said "especially through a web form"

    Except for a mistake in your Level formula (missing a paranthesis)


    =IF(OR(ISBLANK(Likelihood1), ISBLANK(Impact1) ), "", Likelihood1* Impact1)


    I can't reproduce your problem when I add a row by updating another column or either the Likelihood or Impact columns first.

    Or from a WebForm.


    Are either Level or Rating in your WebForm?

    I tried that and still could not break it.






  • MarkC
    edited 04/26/16

    Thanks for getting back to me Craig.

    Tried it through a number of channels:1

    1. This first appeared through using AppSheet - the formula's are there (if you've the tool)

    2. When adding a row manually underneath an existing on


    I've managed to avoid the issue by including the formular In Level (Likelihood1* Impact1) in the forumla in Rating, which will do, but that wouldn't be ideal in all situations.


    Is there any problem with having the formula in a cell dependent on a cell with formula in ?



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


    I had problems with AppSheet when I put the formula into AppSheet.

    (Not yours, a previous AppSheet test).

    I ended up pulling the column out of AppSheet completely and letting the formula reside in Smartsheet and rely on the autofill from there. 


    When I have time, I will see if I still have that test case available for checking.


    You might also try changing


    =IF(OR(ISBLANK(Likelihood1), ISBLANK(Impact1) ), "", Likelihood1* Impact1)


    to this


    =IF(OR(ISBLANK(Likelihood1), ISBLANK(Impact1) ), 0, Likelihood1* Impact1)


    so that both Level and Rating will have value if nothing is entered in the other two columns.



  • MarkC

    Thanks for your help Craig & will give it a try tonight

This discussion has been closed.