Sign in to join the conversation:
I am trying to make a formula where IF the dropdown in row B selected is 50/50, THEN the dollar amount in row A is divided by 2. Does this make sense? Is there a way to formulate this?
Hi,
Do you mean columns or rows?
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
I hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
I want the Total to be if 100%, then Total Dollar stays the same. If 50/50, then Total is Total Dollar Amount divided by 2.
Ok.
Try something like this.
=IF(Billing@row = "50/50"; [Total Dollar Amount]@row / 2; [Total Dollar Amount]@row)
The same version but with the below changes for your and others convenience.
=IF(Billing@row = "50/50", [Total Dollar Amount]@row / 2, [Total Dollar Amount]@row)
Depending on your country, you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work, or did I misunderstand?
It worked! Thank you!!
Excellent!
Happy to help!
I apologize, one more question. If I wanted to add another rule to that statement where it would say if it's 100% Distributor in the dropdown, then the total is 0, how would I add that in so that there's two rules for that cell?
No worries!
=IF(Billing@row = "50/50"; [Total Dollar Amount]@row / 2; IF(Billing@row = "100% Distributor"; 0; [Total Dollar Amount]@row))
=IF(Billing@row = "50/50", [Total Dollar Amount]@row / 2, IF(Billing@row = "100% Distributor", 0, [Total Dollar Amount]@row))
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
It worked. Thank you so much!!
I'm always happy to help!
Is it possible to auto-populate an email domain in a field where people are asked to enter their email address? For example, I would like users to only have to type their name, without needing to enter anything after the “@” symbol, to reduce the chance of personal email addresses being entered.
This discussion was created from comments split from: I am an editor on a smartsheet but can't edit the sheet.
Good afternoon! My company works closely with another ambulance service, Company B. Both companies have a Smartsheet Enterprise plan. I have created a workspace that I need members of Company B to edit. Do I need to make them members on my account if they are already members on their account? Or do I just need to add their…
