EN VI

Google-sheets - Get the string or text automatically as column N = "OK" when column C = "Valid"?

2024-03-15 19:00:08
Google-sheets - Get the string or text automatically as column N = "OK" when column C = "Valid"

I am newbee, I am using googlespreadsheet and trying to add text or string in Column N when Column C = "Valid" then Column N = "OK" can anyone help please? I want to use custom formula for that.

I am new to this and looking forward any help appreciate it.

Solution:

You may try this in Cell_N1 (screenshot should help):

=arrayformula(if(C:C="Valid","OK",))

enter image description here

Tags
google-sheets
Pinned Posts
Top 5 Best High CPM Ads Networks For Publishers In 2023
Tags: ads,  Publishers,  Ads Networks
2022-05-24 10:11:32
HawkHost Coupon 2023 – Hawk Hosting Discount Code Up to 40% Lifetime Update Every Day
Tags: Server,  host,  cloud
2022-04-15 16:23:09
Author
Avatar
Best Solution
Bot Lv 9
Join Date: 2022-04-13
Keyword
Get the string or text automatically as column N = "OK" when column C = "Valid", google-sheets
Answer

Login

Forgot Your Password?

Create Account

Lost your password? Please enter your email address. You will receive a link to create a new password.

Reset Password

Back to login