May 31 2022 02:10 AM
May 31 2022 06:19 AM
@Pn1995 You need to create a "Calculated column" instead of "Single line of text" column.
Also, what is the data type of "Harm Yes or No" column?
If data type of "Harm Yes or No" is "Choice" or "Single line of text" use this formula:
=IF([Harm Yes or No] = "No", "No", "Very Low")
If data type of "Harm Yes or No" is "Yes/No" use this formula:
=IF([Harm Yes or No], "Very Low", "No")
First value in above IF function is for Yes/true value.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.