Forum Discussion
SharePoint List Form Header
- Feb 25, 2022
SG523 Disregard my last answer. The fact that [$Closed] is a calculated column changes everything. Calculated columns are not available in custom form formatting since they are only calculated when the record is saved.
To make this work, you need to use the formula that is used in the calculated column in the formatting json. For example, if the [$Closed] column calculation is
IF([Status] = "Closed", "Yes","No")
Then use the same formula in the formatting json like this
"iconName": "=if([$Status]=='Closed','BoxCheckmarkSolid','BoxMultiplySolid')",
Hopefully this will fix the problem!
Please click Mark as Best Response & Like if my post helped you to answer or resolve 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.
SG523 Disregard my last answer. The fact that [$Closed] is a calculated column changes everything. Calculated columns are not available in custom form formatting since they are only calculated when the record is saved.
To make this work, you need to use the formula that is used in the calculated column in the formatting json. For example, if the [$Closed] column calculation is
IF([Status] = "Closed", "Yes","No")
Then use the same formula in the formatting json like this
"iconName": "=if([$Status]=='Closed','BoxCheckmarkSolid','BoxMultiplySolid')",
Hopefully this will fix the problem!
Please click Mark as Best Response & Like if my post helped you to answer or resolve 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.
This was the problem! Sorry I didn't include the calculated column info right off the bat. That was my fault. Thank you for the great explanation of why as well.
As for the Logo, I'm not sure how to add an image in the header and I would like to put one in there on the left side of the header. I have the image I want saved to my Site Assets on the same SP site but I have no idea what the Json would look like to include an image from my SP site assets. Can you help with that?
- Don KirkhamFeb 27, 2022MVP
SG523 I can help you place a logo in the header. It will help me if you create a new request for that. Feel free to tag me in the request so I can easily reply.