nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

If function

Office

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

Find more posts tagged with

Formulas

Comments

Chris McKay

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:

Checkbox (Checkbox format)
Amount Before (Text/Number format)
Amount After (Text/Number format)

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.

Mike Wilday

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.

Office

Thank you

will try this.

sue

Sign in to join the conversation!

Quick Links

Trending discussions

Form Submitter
How do I see who submitted a form for a specific sheet?
Gantt view reporting activity in coming week
Hi, I have a Gantt covering 500+ rows of events past and planned. I use it to predict and track values around these events. Using helper columns to identify the current week, I get an email report on a Monday that tells me the upcoming events in the current week (7 days) and their values. Currently if an event spans…
How to restrict sub-action due dates in a Smartsheet Form?
Hi Smartsheet Community, I'm working on an action management system where users create sub-actions through a Smartsheet Form. The requirement is simple: a sub-action's due date must be earlier than or equal to its parent action's due date. For example, if the parent action is due on June 30, 2027, users should not be able…