Autofill Stopped Working

MarkC

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 !

J. Craig Williams

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

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

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

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