Can I change the text in one column if the box is checked in another column?

For example: Id like to change 'Status' column to "Completed" if the 'Published' column box is checked?



  • SoS | Dan Palenchar
    SoS | Dan Palenchar ✭✭✭✭✭✭

    The general rule is that if you want a column to contain a formula it should be fully automated, you can't have it be manual entry sometime and a formula some other times. This is because any manual text entry will override a formula.

    You can set up a status formula that can automatically display statuses such as "In Progress", "Planned", "Overdue", "Completed", "On Hold", etc., whatever you want really, but to do this you need to enter data in other columns of the Sheet that can be interpreted by a formula to produce the status options you desire.

    For your specific example, your formula would include:

    =IF(Published@row=1, "Completed")

    This formula would need to reference additional columns to determine other status options. If the only options are the item is either Completed or QC in progress... you could use the below formula:

    =IF(Published@row=1, "Completed", "QC in progress...")

    This formula would put QC in progress... as the default value, once the box in Published was checked the status would change to Completed

    👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner

    If this helped, help me & the SSC by accepting and reacting w/ 💡insightful, ⬆️ Vote Up, and/or ❤️Awesome!

    PS - If you have a follow up response tag me @SoS | Dan Palenchar so I get notified of your reply!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!