Sign in to join the conversation:
If column 1 has the word "yes" is there a formula that will place a value of "482000" in column 2?
Thanks in advance
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
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
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))
Andrée
Thanks for your help. It worked just like I wanted it to.
Great!
I'm always happy to help!
How can I delete old sheets I no longer use from my account?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
