nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Formula

Stephanie Taylor

If column 1 has the word "yes" is there a formula that will place a value of "482000" in column 2?

Thanks in advance

Find more posts tagged with

Comments

Andrée Starå

Hi Stephanie,

Try this.

=IF([Column 1]1 = "Yes"; 482000)

The same version but with the below changes for your and others convenience. =IF([Column 1]1 = "Yes", 482000)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Stephanie Taylor

Andree,

Thank you, that works great! Now let me take it one step further. How do you adjust the formula to include if column 1 is "No" then the value in column 2 is "481000"?

Thanks again,

Steph

Andrée Starå

Happy to help!

Try this. I've also updated the formula with the @row function so you don't have to worry about the row numbers.

=IF([Column 1]@row = "Yes"; 482000; IF([Column 1]@row = "No"; 481000))

The same version but with the below changes for your and others convenience.

=IF([Column 1]@row = "Yes", 482000, IF([Column 1]@row = "No", 481000))

Best,

Andrée

Stephanie Taylor

Thanks for your help. It worked just like I wanted it to.

Andrée Starå

Great!

I'm always happy to help!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

"Fields marked with an asterisk (*) are required." line on every form.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
Dynamic View Issue - Group Sharing
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…