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.Formula for calculated value showing as metadata
Hello, I have a User who was able to automatically tag files with metadata based on folders in SharePoint per the video https://youtu.be/Tq5zibnXkhY. However, one attribute is a calculated value, =TEXT(Today,"YYYY"), used as the default value. The formula, =TEXT(Today,"YYYY"), is showing instead of the calculated value. What can be done to fix this?
Create 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 Done
How 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 Westman
Calculated Column in Doc Library Not Working
Hello, I have created a document library and a SP list that has all the same columns. In both, each has a calculated column [Cost Unit (Auto)] based on the output of another column [Cost Center]. For example: When I selected "55 IT" for [Cost Center] the calculated column [Cost Unit (Auto)] should output "400 Admin". It works for the SP List but not in Doc Library. Doc Library using Calculated Column [Cost Unit (Auto) Output "No" I applied the same syntax from the calculated column in my List to the Doc Library, I assume it wouldn't need to be any different? My route was to go with a SP list, but the users would need to add attachment to each item in Form view not making it as efficient. This is why I created a doc library to test a work around but had a problem with the calculated column. Bummed me out! Any help would greatly be appreciated! Thanks!
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.
