Autofill Stopped Working

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 !

Find more posts tagged with

API and Developers

Integrations

Comments

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