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!
I'm receiving this message every time I try to open my sheets. I'm the only admin user. I have already performed proper troubleshooting, such as clearing the cache, logging in incognito, and logging out and back in, but the issue remains unresolved. It's been a few days, and I'm unable to track our projects and this…
I’ve created an automation that generates a document and forwards it to the individual specified in a cell. The line item also has several additional attachments associated with it. Is there a way to include those attachments with the generated document?
I have an automation set up that copies a row to another sheet each day. The automation itself works correctly, but the problem is that it copies the formulas rather than the values, which causes the formulas to break and return errors. How can I configure it to copy only the values instead of the formulas?
