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!
The Issue My project-specific metadata sheets use INDEX/MATCH formulas that reference the Intake sheet using a Project ID. When the automation archives rows from the Intake sheet, these formulas break because they can no longer locate the source data. Example formula: =INDEX({Project Intake Name}, MATCH([Project ID 1]@row,…
Two of my five automation workflows appear to have just randomly stopped performing on April 9, 2026. All others, which would/are performing as normal and would be functioning alongside the other workflows, are functional and appear to be untouched by this 'bug'. Help I've tried all that I can think of.
I need to add 2 horizontal lines to my stack chart to show when we have over allocated for our resources and where our average is. Does anyone know how to make this happen in a Smartsheet dashboard?
