Automatic antick

Hello,

I have a particular situation: 4 columns defined as checkbox. The description of the columns reflect a sequence: Open, In progress, Pending and Closed. I need that when I tick a subsequent columns/status the previous one (or the others) will be automatically unticked.

Could you please help me?

Thanks and regards.

Find more posts tagged with

API and Developers

Formulas

Comments

Andrée Starå

Hi,

You'd have to use a third-party integration like Zapier to do that because if we used formulas, they would be deleted when you change something manually.

Would that work? Is that an option?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Jacob Adams

Hi,

If it is possible, I would recommend using a dropdown containing the four statuses. I personally think this may be a better option. You can use formulas to automatically change the status based on percent complete or any other criteria that you find useful. I hope this helps.

All the best,

Jake

Task Status and Formula.PNG

Andrée Starå

Jake,

I agree but I got the feeling that the OP wanted check boxes.

Best,

Andrée

Hello,

I've already proposed your solution, but the manager need specific checkbox columns and a function that when a user check a column (so new status), automatically the system remove the tick from the other columns.

Thanks and regards.

Antonio

Automatick untick.jpg

Andrée Starå

Ok.

Does the Status open column need to able to be checked manually?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Best,

Andrée

Hi,

For example, I have a row with the tick only on the field "Status Open" so:

Tick the field "Status in progress" in reference to the same row.
The system automatically untick the initial selection of the field "Status Open" (now we do that manually).

Andrée Starå

Do you tick the "Status Open" manually today? If yes, is there something that we could use to decide when it should be ticked automatically?

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…