List
34 TopicsConditional Formatting based on one field
I have a modern Sharepoint list with a Status field. If the status is selected 'To Be Removed' I'd like to strike through the entire row. I can't find an example like this online, would someone be able to advise what the JSON for this would be? Apologies - I'm a complete JSON beginner! ThanksSolved4.6KViews0likes3CommentsSharePoint List. Gallery Formating
Good morning everyone. I'm trying to use a list to host a series of hyperlink. My list has 3 columns: 1) Title (The default one) 2) Topic (Hyperlink column) 3) Language (Radio button choice) I want to use this list as menu. Similar to the quick link Object in SharePoint (modern). I made all columns but "topic" invisible I created a Gallery view and ensure the column header doesn't appear in all items Now, I have no clue on how to format each tiles. If I make the font size bigger, the bottom of the text is cropped. If I make the size of the box bigger on list, I see the result but it's not reflected on what I see on Sharepoint So, my questions. 1) How to make my boxes larger (in both list and SharePoint) 2) How can I ensure the bottom of my text (The alternative text for the URL) is not cropped (usually the "p, q, g" ) 3) If my text it a bit too long, how can I allow it to take two lines one not only one) 4) How do I remove this little radio button in each tiles ? 5) How do I change the background color of the list object on SharePoint, the background and the background of the tiles ?1.4KViews0likes1CommentAdding an Appending Multiline Text Field to a List Board View
I have a board view with all our tasks running. I would like the most recent comment to show on the card so we can see it when we are reviewing the cards without opening them up. When I add it to the card it does this It puts in the HTML for a link that says "view entries". Is there a way to display the most recent item to an appended multiline text field to a card in a Board view or in any list view? I know I can build a Power App, but I don't really want to for this.Solved1.5KViews0likes2CommentsSharePoint Online List Webpart Views Ignored (Team site Classic Experience)
Can anyone confirm that none of a list's views can be applied to it inserted in to a page as a web part? The Web Part Properties section gives the following message if anything other than All Items is selected for Selected View: Cannot save all of the property settings for this Web Part. Cannot complete this action. Please try again. I thought the issue might be with my custom list, so I created a new list using the Recipe Tracker template. I made no additions, changes, or edits to the list content or definition. I created a new Web Part page and inserted the Recipe Tracker Web Part. The behaviour is the same. Steps to reproduce: Go to https://<yoursite>.sharepoint.com//_layouts/15/viewlsts.aspx Click on + New Click on List Scroll down and click on Recipe tracker in the "Templates" section under the "From Microsoft" tab. Click on Use template Click on Create Go to https://<yoursite>.sharepoint.com/SitePages/Forms/AllPages.aspx Click on + New Click on Web Part Page Type in a name for the page in the "Name:" text box. Select Full Page, Vertical in the "Choose a Layout Template:" list. N.B. the selection here did not seem to make any difference to the outcome. Select Site Pages in the "Document Library" drop-down. N.B. the selection here did not seem to make any difference to the outcome. Click on Create Click on Add a Web Part Click on the right-facing arrow until you see Recipe tracker in the "Parts" list. Click on Recipe tracker Click on Add Select the Recipe tracker web part Click on Web Part tab at the top of the ribbon Click on Web Part Properties in the "Properties" section of the ribbon Select Recipe gallery from the "Selected View" drop-down in the "List Views" section on the right-hand side of the page Click on OK Receive error message, and the view has not changed.862Views0likes1CommentCreate a calculated column which will display a combination of values from multiple different rows
I'm trying to create a calculated column which will display a combination of values from multiple different rows. In my example list below, look at the "Dependencies" column for User "George". I would like to display the status of multiple users duties in this column. Hopefully this can be done without creating a second list? In my real list, there are over 1,000 items and the dependencies are not in order. User Job Duty Status Dependencies Hank Buy Supplies Done None Judy Bake Cake Done Hank Bought Supplies : Done Brent Package Cake Not Done Judy Baked Cake : Done George Send Cake Not Done Hank Bought Supplies : Done Judy Baked Cake : Done Brent : Not Done872Views0likes2CommentsHow to create a rolling calculated column in sharepoint list
Hi- first time posting here, and new to sharepoint. I have a sharepoint list in which i have some basic calculating columns totaling hours and units worked on a day's shift per employee. I was looking for some insight, if a calculated column could be made using a rolling time calculation for instance towards a payroll date. This will allow me to group all entries by a pay date. payroll is sent out on the 15 & 30th of every month. I plan to have this sharepoint list as a data source into power bi & /or excel i can easily group the employee's total per pay period and have it vlookup again a payment table. However if i can group by a payment period that would greatly impact my over all goal. Thank you for taking to time to review my question Drew Westman1KViews0likes0CommentsCreating unique ID's in bulk
Hi, I want users to be able to "book" 99 unique ID's as they please, in my SharePoint List, and it needs to be sequential. So when a user clicks "new" a new row with a bulk of 99 unique ID's are created, which the user can assign to himself. Example: 1. | A00000 to A00099 | Assigned to Jeff 2. | A00100 to A00199 | Assigned to Jeff2 3. | A00200 to A00299 | Assigned to Jeff3 Etc. I will have two others columns where I can designate the number being taken, and who took it. However, for the ID column (see example) I am not sure on how to format it, so that it would produce the sequential ID when a user wants to add a new row (as to book the next 99 new unique numbers). Any immediate ideas? My immediate idea was to manually add a bunch of rows in a single text field, and let users book them, and then manually add new ones when it starts to run out... but I am certain this could be automated. Any help or direction would be appreciated, thanks.1.4KViews0likes2CommentsAdvanced list
Hi all, I would like to create a list of customers in SharePoint, but I am not sure the list feature suits best. I would like to be able to click on a client, and then have it open another page where you can add notes, to keep track of communications with the client. Sometimes it can be a lot of text, if for example there is a need to copy and paste email exchanges. Then, if the latest notes about a client could be displayed in a newsfeed on the starting page of the site, that would be perfect! What would be the best option to do so in SharePoint ? As I said, I am not fully convinced by the list option, as some customers might have long text to be added. Many thanks in advance961Views0likes1CommentWhen formatting gallery view can you make items that appear on the card change based column value?
I would like to have a gallery view that is grouped by a status value such as: "requested" "in work" "complete" and I would like the information displayed on the card to change based on this status. this is to not clog the cards up with information that isnt relevant at that stage. i would prefer this to remain in the same view too thank youSolved2.6KViews0likes8Comments