Sign in to join the conversation:
Please can someone tell me the formula I need if a box is ticked how to move an amount to a different column.
so If mikes ticks is ticked how can I move the amount to amount outstanding.
thank you
Sue
Hi Sue,
That's a pretty vague description, but never let it be said that I don't like a challenge, so I'll have a go.
Let's say you have 3 columns:
You'll want to put your formula in the column you are "moving" the amount into. You are not technically moving anything to Amount After, just referencing the value in Amount Before.
The formula you need to enter in the first row of the Amount After column is:
=IF(Checkbox1,[Amount Before]1,"")
I'd copy this formula down a few rows and lock the Amount After column (right-click on the column header and choose Lock) to ensure nobody accidentally edits/deletes your formula.
The formula will copy itself down the Amount After column as new rows are populated.
You won't be able to "move" an amount per-se, but if you use Chris' formula in the Amount Outstanding column it should copy that amount to that column if the checkbox is ticked. Otherwise, that amount will be 0.
Thank you
will try this.
sue
Hello , I am looking for help to write a formula that will check a box if certain criteria are met. I have students that are signing up for a class and they need the previous class or classes as prerequisites. for example i have class 1, class 2 , class 3 and class 4. each higher number class needs to have completed the…
Hello, I am looking for formula help where I want to return the earliest date in a range for different workstreams groups on a project. The source sheet is formatted as a date field, and the formula used below is returning a 0 no matter what I do. Any suggestions? =MIN(COLLECT({Project Plan - start date}, {Project Plan…
I currently have 14 sheets with the following columns: Batch # and Reviewer I use an Index Distinct formula to acquire the unique batch numbers from all 14 sheets and put them into 14 columns on the 'metrics' sheet. I then use another index distinct to get a list of all the unique batch numbers into one 'Unique Batch…
