使用表单时，公式不更新行号

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.<\/p>","bodyRaw":"[{\"insert\":\"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.\\n\"}]","format":"rich","dateInserted":"2022-04-28T13:48:13+00:00","insertUser":{"userID":9734,"name":"Daniel Richter","url":"https:\/\/community.smartsheet.com\/profile\/Daniel%20Richter","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-04-28T15:27:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/90583\/formula-not-updating-row-number-when-using-a-form","embedType":"quote","name":"Formula not updating row number when using a form"}"> https://community.smartsheet.com/discussion/90583/formula-not-updating-row-number-when-using-a-form

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<\/p>

https:\/\/us.v-cdn.net\/6031209\/uploads\/1FVJANGEPUKV\/image.png<\/a><\/p>

Thanks<\/p>","bodyRaw":"[{\"insert\":\"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\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/1FVJANGEPUKV\\\/image.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/1FVJANGEPUKV\\\/image.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"Thanks\\n\"}]","format":"rich","dateInserted":"2022-04-28T14:30:03+00:00","insertUser":{"userID":9734,"name":"Daniel Richter","url":"https:\/\/community.smartsheet.com\/profile\/Daniel%20Richter","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-04-28T15:27:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/327703#Comment_327703","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/327703#Comment_327703

That seems to have done the trick.<\/p>

Did not know the "@row" thanks for sharing and helping.<\/p>","bodyRaw":"[{\"insert\":\"That seems to have done the trick.\\nDid not know the \\\"@row\\\" thanks for sharing and helping.\\n\\n\"}]","format":"rich","dateInserted":"2022-04-28T20:08:46+00:00","insertUser":{"userID":9734,"name":"Daniel Richter","url":"https:\/\/community.smartsheet.com\/profile\/Daniel%20Richter","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-04-28T15:27:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/327793#Comment_327793","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/327793#Comment_327793