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!
Hello, Im working as a consultant/developer. Im signing up with multiple clients each with their own licenses. They are adding me as I work on their project. May I know if this is possible? Will they adding me have an issue on file/sheet/workspaces view and sharing? Any tips to avoid mixing up stuff? May I know if there…
Hello. I don't have the "add user" link in the "User Management" page of my Smartsheet Pro Plan. I am the administer on the account. I want to add a few outside people who can view files in my workspaces. What is the best way to do this?
Hi, We’re encountering errors when attempting to open an update request via email. Please see details below. Could you advise on the cause and next steps? Thanks
