HI,
I would like create a webpart with a report with stoplight in order to show to our department the status of our applications. I would like that this report is adapted through an updatable excel file.
I didn’t find anything on internet about this subject.
Someone can help me ?
Thanks by advance.
In the document library with your Excel file, make a custom content type based on Document. Add your stoplight column to it. The value of that column will be accessible inside of your Excel file. You can update it from Excel and it will update the column value in SP when the Excel file is saved.
I tried this solution (see link).
http://thinketg.com/creating-a-stoplight-color-coded-status-in-a-sharepoint-list/
But I would like to be able to add some other items/modify directly in the excel file and that my report will be updated automaticaly.
Can use the Excel Viewer web part and have your stoplight in the Excel file.
Could also use a content type and have a custom column that represents your stop light (1=Red, 2=Yellow, 3=Green, etc.) Excel can use the values of columns in your content type. You would then use some CSR to automagically convert the column value to a stoplight graphic in your list view.
