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!
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
Hello team! Hope you all are having a wonderful holiday season. I am trying to set up an automation that will send an email reminder one time when Next Update Date = 60 days, then another automation at 30d, etc. The key is I only want it to send the reminder one time when Next Update threshold is reached. Is this possible?…
Has anyone found a workaround for sharing Smartsheet reports externally without giving access to internal data? I currently have to download the data and transfer it onto excel to create a pivot table for our client and I want to find an easier way to do so. I also already create a dashboard for our client, but I wanted…
