I’ve created a shared expenses table. Within, I have a single-select column A with “Full” or “Split”, in which expenses are split 50/50. The adjacent column B I would like to have a function where “Full” items would be 100% and “Split” items 50%. Basically each cell’s function in column B is affected by column A’s item. Any simple way to accomplish this? Thanks!
Function Affected by Adjacent Column
I’m not sure where you envision your data versus your controls, but let me run something by you that’s along the same lines as your example, and you tell me if it fits or needs adjusting:
{ColumnA}
Single select
values = ‘Full’,‘Split’
{ColumnB}
Numeric
value = $ cost of expense
{ColumnC}
Formula
formula = IF(ColumnA='Split',ColumnB/2,ColumnB)
Is that kind of what you had in mind?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.