How do I create an IF formula with checkbox?

Hi there!

I'm trying to create a formula using a checkbox and I'm really struggling. Using the parameters below, can anyone help me with the formula?

Column 1 = Australian states/jurisdictions (SA, WA, etc)

Column 2 = Complete column with checkbox

PROBLEM: If Column 2 is checked in Row 1, I want Column 1 in Row 2 to automatically populate with 'SA'

Any assistance would be greatly appreciated!

Thanks,

Phoebs

Find more posts tagged with

Healthcare

Formulas

Cell linking

Try puting the formula below in Row 2 Column 1, Where Column 2 = Complete and is a status box.

FYI - A checked status box has a value of 1 and unchecked status box has a value of 0 when calculating values in IF statements

=IF(Complete1 = 1, "SA", " ")

VLOOKUP vs CONTAINS
This discussion was created from comments split from: How to detect multiple dropdown values in a contains function?.
Using SUMIFS with Cross Sheet References and CONTAINS
There seems to be lots of information on how to use SUMIFS with a CONTAINS criteria, referring to another sheet. Here is my formula on Sheet 1: =SUMIFS({Total Cost - Final Event Space Cost}, {Requested Event Date}, {Requested Event Date} > TODAY(), {Requested Event Date}, {Requested Event Date} >= TODAY(-365)) Total Cost -…
Networkdays when doing sums
I have a working formula (below) that works well, but includes weekends in the return. I am finding a date in a range, and then adding Duration per products X #products. How do I get it to work with weekdays only? =MAX(COLLECT(Assigned:Assigned, Priority:Priority, "HP 1")) + (MIN(COLLECT([product counts]:[product counts],…