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
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…
Hello, I use Smartsheets in a Higher Education setting. I have one sheet (Sheet A) for a list of students this sheet contains their student id numbers, email addresses, as well as other helpful information. I built a If Yes/If No check column on this sheet as well. My next sheet (sheet B) is a form that is asking is the…
I need to extract information from 2 different sheets based on the name of the member organisation and the join year (i.e. DD/MM/YYYY). The 2 sheets have the same column titles, but one is for 2024 and another one for 2025. Where organisation joined earlier than 2025, then it needs to fetch the data from the 2024 sheet,…
