Sharepoint column value (status) based on other multiple column values

Hi Akshadaks,

you can use a calculated column for that.

In this example I have a list with three Yes/No columns: YNField1, YNField2 and YNField3

Now press "+Add Column", select "See all column types" and press "Next"

Name your new column "Status" and select "Calculated (calculation based on other columns)"

Now enter this formula into the Formula field and press the "OK" Button on the lower left side.

=IF(
	AND(
		[YNField1]=TRUE,
		[YNField2]=TRUE,
		[YNField3]=TRUE
		),
	"Approved",
	"Rejected"
	)

Now your list should look like this

The new status column will display "Rejected" unless all of the "YNFields" are true.

Best Regards,
Sven