Forum Discussion
mljohnson220
Jun 12, 2023Copper Contributor
Calculated Column MS 365 Sharepoint
I have the following columns in SharePoint: Subject, In/Out, Date of Transmission, Unique Id. Subject column is a text field, In/Out is a choice column with the two dropdown options 1. Incoming, 2. O...
RobElliott
Jun 12, 2023Silver Contributor
mljohnson220 I think your main problem is that SharePoint doesn't support the COUNTIFS function. You can't loop through and count all items in a list in a calculated column.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
mljohnson220
Jun 13, 2023Copper Contributor
RobElliott thanks. Any suggestions on how to achieve the objective?