Sign in to join the conversation:
Hello,
I want to configure a formula to set the current date when 2 checkboxes are checked.
I have configured 1 date column and 2 checkboxes columns.
I don't want to use the auto-modify date column for this purpose.
Please help.
Hi Hans,
Date/time enhancements are coming that probably would help in your use case, but I don't know when or the specifics.
In the meanwhile, the third-party service, Zapier, is an excellent option for this scenario. Is that an option for you?
Do you need the ability to change the row after the checkboxes are checked?
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)
I hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
Good morning, We have an absentee calendar for approximately 150 employees, including 30 supervisors. Supervisors absences must be notified to a specific group. Automation works well for single day absences, but when an absence spans multiple days, the supervisor is not consistently included in daily (Mon-Fri)…
Hello All! I have an automation that is set as Trigger: When a Date is Reached —> Run Once on Date at 5pm. Conditions: Where two separate checkboxes are checked. Alert someone—> Message, Link to sheet and specific fields (an attachment). The automation worked except the attachment. It wasn't included at all on the…
Hello, I'm trying to write a Summary Field formula that will count the number of unique days in the Created date (titled Date Added) system column without using a helper column or metric sheet. I am able to get the correct total, and the list of dates counted, when I use the Analyze data AI Tool: However, I'm not having…
