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. ...
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