Welcome!

How do i - If this is checked , then check this on another sheet?

i have 2 sheets to reference

first sheet has a confirmed check box column

but on another sheet i want it to check a box as a pilot user if the confirmed was checked...

is there a way to do this with a formula?

Formulas

Hi,

The simplest way would be to use cell-linking and link the checkboxes.

Would that work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Cut-off Date
Hello I am looking to create a Smartsheet formula that returns the following result: Column A "Created Date" - this column type is a Created date and show results with date and time Column B "Received Date" - this column would round up the "Created Date" and just show date, no time. If the "Created Date" was after 2:00pm…
Create sequential IDs based on columns responses
Trying to create automatic sequential ID numbers based on the date to ship and where the sample goes. Have a general auto numbering Row ID, have (thanks to reading other questions and responses) figured out how to designate a year. Now I would like to number the Internal (INT) shipments separately from the external…
How to link to data in one sheet and transpose the data in a new shieet
I have a sheet that has data displayed both horizontal and vertical. The primary data is horizontal (date) with information below each date, 4 rows of data. After the data the dates for the next set of data is horizontal with information below it vertical. 1/5/26 1/12/26 1/19/26 1/26/26 JP OS TT LL OS RT RR SS That data…