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!
Hi everyone, I'm the owner of worksheet/workspace and am currently unable to reliably remove user access through the "Manage Access" panel. This issue just started occurring recently. The Problem: When I click the "X" next to a user's name to remove them, it works for the first user. For any subsequent user, the "X"…
I'm trying to move data from two grids (Grid #1 and Grid #2) using workflows (When rows are changed) to archive grids when a cell is ONLY updated on Grid #1. Here is my setup and what the issue I'm having… Grid #1 has the column that is being updated. Workflow setup on Grid #1 to move the row when the cell is changed to a…
Helloe Everyone! I’m trying to reference another sheet in Smartsheet, but I’ve noticed that sometimes it loads quickly, while other times it takes a very long time to display the list. Does anyone know why this happens? Is there a way to reduce how often this issue occurs? Today, I can’t get anything to load at all. 😑
