Forum Discussion
Auto-populate row completion?
Hi there,
I have a SharePoint list where the columns are Create Date, Request #, and 5 employee names. Each employee goes into the list and marks if he or she has completed the request, or not.
What I Want: I want to add a column titled "Status" where it will automatically fill in the words "Selections Complete" when all 5 employees have made a selection. If possible, also send an email to a recipient of my choice. It doesn't matter if they choose Complete or Not - all that matters is that they have made a selection of Complete or No.
Is this possible? I understand the list I made is a little bit unorthodox with each employee being a column.
Thanks.
Hi seppy
Maybe a calculated column could be used for the final status in your case. In the screenshot, you can see an example from my test environment using two input columns.
The calculated column formula (use ',' or ';' as a parameter separator based on your language).
=IF(AND(NOT(ISBLANK(Choice1));NOT(ISBLANK(Choice2)));"Selections Complete";"Selections Incomplete")
Regarding sending emails, you can use a Power Automate flow with the "When an item or a file is modified" trigger to catch changes on the items and react accordingly (for example, by sending an email when certain conditions are met).
- Thanks for responding. Can you tell me where I'm supposed to enter that IF equation? Is that directly into the JSON area or is there a special column type?
- The IF statement should be added to the formula of a newly created Calculated Column type
