Concatenating Multi-Choice Field
I have a modern Sharepoint list with Fields including: Speciality - Choice (Multiple selection allowed) SME - Person I'd like to concatenate them into a single line of text. I can't use the Calculated column I believe due to the multiple choice. I tried Flow but really struggling to get anything to work as I keep getting 'Apply to Each' and it won't let me extract the data. Anyone have any suggestions? Many Thanks
Filtering on Calculated Columns not working in SharePoint List
I have a table where i created a calculated column for the Fiscal Year/Quarter = Example: FY2023/Q3. I used to be able to filter on this field but now when i filter on it, it provides 0 (ZERO) results. Any suggestions as to make this work again? Thank you. If i have to, i can create a flow to pull the calculated column into a text column...if I have to...but id rather not.
Calculate date based on current years week number and specific week day
Hi, Is there any way to, in a sharepoint list, calculate a date based on 2 columns containing (1)current years week number and (2)a specifik week day. Current year=2023 Column1: 28 Column2: Tis (Tuesday) The calculated date for current year would be 11072023 (DDMMYYY). This is for a planning tool, presented in powerapps, where a great deal of the events repeats every year. In order for me to highlight events in future I need a date. I was able to do it in PowerApps (calculate date based on said columns) but I have problem using/reaching that date more than presenting it, if I had that date in a column from the data source I thought it would be easier.IF formula error message "The formula contains a syntax error."
Hi all. I'm trying a very simple IF formula in a calculated column at my data list. =IF([Monitorar]=0;"0";"1") I tried replacing the ; by , and not solved. I also tried replacing IF by SE (note that my Microsoft account is in portuguese), and not solved. I tried in another browsers, an nothing different happens.
PivotTable - Calculated Field Subtotal
I inserted in a calculated field into a pivot table that multiplies 2 values (this field is titled "sum of Prod Routing Hrs" in the table (see screenshot) and the automatic subtotal on the date (in the row field) will also multiply the values instead of sum them like it does for the other values. Any ideas on how I can fix this? I have also included a screenshot of the calculated field.
Modern grouped view not displaying results
I have a Modern library filtered and grouped view that displays "Show All" when the expanded group exceeds 30 items. Upon clicking "Show All" or the group heading itself to view all items in that group, it does not display any results, however it works perfectly in Classic experience. The library has hundreds of document sets – one for each Job Request – so we have created a view that filters for Document Sets only and excludes several values of a Calculated Column (i.e. "Job Status" is not equal to...), then group by the items by the same calculated column ("Job Status"). The problem appears to be grouping using THIS calculated column (contains IF statements) – the same view works when I select any non-calculated column or another concatenated calculated column to group by. When I re-introduce this particular calculated column for grouping (even at a second level) it fails to display results again but again will do so correctly in the Classic Experience! PS: Also, is there some way to configure for more than 30 items before "Show All" appears (PS: I have increased the collapsed number of groups to display value but this doesn't affect Modern "Show All".
