Auto fill information in sheet when a check box is checked in a different sheet

Hello All!

I am trying to figure out how to auto fill information into my sheet, when I check a box in a different sheet. I am keeping track of different invoices and sponsorships in the original sheet.

When I check a box in the column "Ad" then I want the "Organization", "Event", "Start", and "Due" columns to auto fill in another sheet. Is there any way I can do this?

Thank you!

Find more posts tagged with

Sheets

API and Developers

Integrations

Solution Center

Conditional Formatting

Comments and Conversations

Update Requests

Cell linking

Email Notifications

Comments

Paul Newcome

Yes. Depending on your setup this could actually be pretty straight forward for you.

Are you able to provide some screenshots with "dummy data" to show exactly what you are trying to accomplish?

Leanne R

Paul

would you be able to elaborate?

I am attempting to do the same thing - where a check box being ticked in one sheet auto-populates information in another sheet

Paul Newcome

Are you able to provide more details as to your set-up and provide screenshots with sensitive/confidential information removed, blocked, or replaced with "dummy data"?

Does the information need to be used further after being pulled or is it just for display (a report would work for this)?

Sign in to join the conversation!

Quick Links

Trending discussions

Update Columns API Possible Bug - unable to clear all options in a MULTI_PICKLIST column
NOTE: I tried to file this several times a support ticket, but the AI BOT was unable to create a ticket and the OG Support Portal no longer allows the direct creation of tickets. Grrrrrr. ISSUE: It appears that the Update Column API PUT https://api.smartsheet.com/2.0/sheets/{sheetId}/columns/{columnId} fails to work as…
what is the cause of "Unexpected character encountered while parsing value: <. Path '', line 0, pos"
what is the cause of "Unexpected character encountered while parsing value: <. Path '', line 0, position 0." error when using the C# SDK. the full log message is: - 2025-09-18 09:58:54 *** Exception in 'ProcessShares(Entity, EntityName, EntityId, Counter, ssWorkspace)' 2025-09-18 09:58:54 1 'ShareResources.ListShares()'…
How to access the new end points via SDK
We were using python SDK to access smartsheet API's. Have seen most of the end points getting deprecated and provided new end points. Its providing the request with all params using direct API request in documentation. However no reference provided for using python SDK/other SDK's to access the API. Is Smarthsheet API…