Forum Discussion
Solved
Create a Table with the top 2 rows as header
I have a new Excel sheet pre-formatted and ready to convert to a table. The top two rows are intended to be the header. The data is intended to start on the 3rd row. I can't get the "Insert table" function to format this configuration. When I attempt to format the sheet as a table with headers, it places the header in the row 3, which is where my data should start, and my intended header rows do not become the header. Please reference the attached file. How is this supposed to be done?
I need a row to sum each of the columns as rows are added to the table.
Holly-CMS You cannot update the value of SharePoint default Title column using formula.
My suggestion is modify formula in Power Apps to update the Title column same as how you are updating the ITRequestID column now. This will be the best approach to follow.If you cannot modify power apps for any reasons, you can create a power automate flow which will run on item creation/update (trigger - when item is created or modified) with single "Update item" action - you can use this action to populate Title column value based on ITRequestID 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.
8 Replies
- Thank you. The colored coding means red right and blue left. So, I can use that to distinguish
wcstarks Indeed you can't . Table headers are just texts. You can't reference to a "red header" or a "blue header".
I see that each column header needs a unique name, so I adopted your suggestion (R-250, etc.)
The data are numbers. minus numbers indicate reducing the db (loudness) and positive indicates increasing db for each frequency. I would like to have row 2 sum each column as rows are add to the table to provide a net db change for each frequency. I am not sure how to do that when the summation row is situated before the the regular data rows. Is this possible? See attachment.
wcstarks You simply can't have a structured table with two header rows. Just call the headers R-250, R-500 etc. and L-250, L-500 etc. or something similar.
