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

Options
MarkC
MarkC
edited 12/09/19 in Archived 2016 Posts

Hi,

 

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 !

Comments

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

    MarkC,

     

    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.

     

     

    Craig

     

     

  • MarkC
    MarkC
    edited 04/26/16
    Options

    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 ?

     

    Thanks

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

    OK.

    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.

     

    Craig

  • MarkC
    Options

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

This discussion has been closed.