Automatic Checkbox

Hello I am trying to get a checkbox to automatical put a checkmark in it when a certain status (done) is written but I cannot get it in the conditional formating. Also trying to get the rule the other way as well so that if checkbox is checked that status changes automatically to done but can't seem to find it in the condition. Any ideas?

Find more posts tagged with

Formulas

Comments

Mike Wilday

Hello Consey Coffee,

You can add formulas to both columns to do the trick. In the Statut Column Row 32 add IF(Terminer32=1, "Done")

In the Terminer column row 32, add "IF(Statut32="done", 1)

Be warned however, if you have formulas in those columns, then they become uneditable in a report. Users can't edit fields that contain a formula. Also, if they overwrite the formula field you may have issues with it auto-filling to the next row.

You may want to consider user-workflow in this case and make sure that your users are either 1) editing rows on the main smartsheet or 2) limit what your users do, either write done, or click the checkbox. Maybe also consider using a dropdown column on the statut row so that users can select a status... and keep the checkbox as a formula item.

More on cell-linking and reports: https://community.smartsheet.com/discussion/cell-linkingformulas-reports

More on auto-fill: https://help.smartsheet.com/articles/1641473-auto-filling-formulas-and-formatting... if the final row in your smartsheets contains a formula, new rows will also populate with that formula. but if you overwrite the formula with text auto-fill stops working.

Consy Coffee

where do I put the formula exactly?

Consy Coffee

i am sorry I don't really understand how to get the formula in the collumn as I already have a given rolldown menu to choose from... or a checkbox to click on

Mike Wilday

Double click on the rolldown menu, or on the checkbox to get a textfield and then paste the formula in there. Then you can enter the formula there. Users will be able to select the dropdown or enter the checkmark from the original sheet only.

Consy Coffee

I have tried I can't do it as it keeps erasing information in my scroll down menu and it doesn't like that I ask one to do something ot the other and the oppiste, says blocked because of double reference or something like that. unparseable

Mike Wilday

That makes sense, it becomes circular reference if one relies on the other. Unless someone else has another solution, I think you're going to have to consider the workflow for this piece. Either use one method or the other. Have users click a finished checkbox and have the status write Done. OR, have users select the status via a dropdown and have the checkbox check off automatically.

You might be able to do what you want by integrating a third party solution called Zapier but I don't have much practice in that. J. Craig who can be found on the All-time tab on the scoreboard can help you with that. His contact information is in his profile.

Robert S.

Hello,

Thanks for the question. Mike's latest response is correct. Formulas that reference each other will cause a circular reference and are illogical statements, so they aren't possible. To make this possible, you can have it go one way or the other, but not both.

Another reason for this, is if a cell contains a formula and is then manually changed the formula is deleted from the cell. This is the case for any update to the cell, such as checking a box or changing the text shown.

To become more familiar with writing formulas in Smartsheet, take a look at our help center on this (https://help.smartsheet.com/articles/2476171).

Robert S.

Hello,

To become more familiar with writing formulas in Smartsheet, take a look at our help center on this (https://help.smartsheet.com/articles/2476171).

davidnguyen

thanks for problem link to HELP page Robert.

Sign in to join the conversation!

Quick Links

Trending discussions

Status Log Push to Dashboard
I want to push the latest status log sheet entry to the dashboard. I have added working columns for the last date, recent value (0 or 1) and recent status (text field). The recent columns are blank except for the most recent data rows (that part of the sheet is working). I have a project metric sheet template across topics…
Calculate Project Time TOTAL for PM across aligned projects
Hi - I am trying to figure out how to create a SUM of the Total Project Time aligned to each PM for all of their projects. On my master sheet I have the Resource Type, Resource Name, and a Helper Column for Time. The Helper Time is an estimated allotted time based on the timeframe of the project. Example: <3 months = 25…
How to Create Time Duration
I have a report where I need a formula to figure out time duration. For example, employee starts at 8:00 am and ends at 9:00 am, I need the next column to tell me 1.00 to indicate he worked 1 hour. I will be using military time throughout this sheet.