Copying down cell entry into blank cell - sharepoint list

Copper Contributor

I have a SharePoint list that info is added to from a third party form. When an row is added to the list we are not getting the info placed into all the cells in the column, how do I copy the info down from the cell above if the cell is blank.

I have tried 

=IF(ISBLANK([Column]),[Column]-1,[Column])

in a calculated columns but this is only coping the info in the fist row and then adding -1 to the following row if blank  

 

Andyslandy_0-1678788310375.png

 

 

1 Reply

@Andyslandy You cannot do it using calculated column formula because you cannot refer value from another list item/row in calculated column. They can only use the values from same item/row to calculate new value.

 

However, you can do it manually using Edit in grid view option by dragging column values similar to this post: How do we vertically delete values from a single column? 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs