Form is set to enter new data in top row since 2016. This week it no longer updates the row to "1" in the formulas, it makes the new row 1 reference row "2" in the formula.
How about showing us your formula?
Is it a column formula or cell formula?
Did someone sort the sheet differently and move an existing row 1 someplace else in the sheet?
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Many of the columns have formulas this is an example of on that just got put into row "1" but left the row number as "2". The row below updated correctly to row "2". Happening to 3 different sheets I have
Are you familiar with column formulas, and using @row to make your formulas apply to every row without working about the position in the sheet? Here's a help sheet on it: https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas
Essentially, every place where you specify the row number in your formulas, replace the row number with @row. For example, in the formula you show, change to:
=IF(Hold@row, "ON HOLD", IF([Part Number Complete]@row <> "", "COMPLETE", IF(Complete@row <> "", "Part Number" ... and so on. Just do this on the top row of your sheet. When done, right click on the cell with the formula, and down at the bottom of the cell menu, select "Convert to Column Formula". The formula will then apply to every existing row in that column, plus all new rows that get created. And it doesn't matter where the row is in the sheet. You could move row 1 down to row 500, the formula still works.
Once you have column formulas in place, to change the formula for all rows, right click and choose "Edit the Column Formula," and any changes you make apply to every row immediately, no extra steps.
That seems to have done the trick.
Did not know the "@row" thanks for sharing and helping.
Happy to help. @row was a gamechanger when it came out, column formulas even more so. They save so much time and ensure things work as they should.
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.