Today Formula
Hi, I am trying to write a formula to show today's date when a checkbox is selected. The name of the checkbox field is "Completed". Thank you ------------------------------ Fatima Khan ----...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI can help you with a formula, but the issue will be that Today keeps changing every day, so that date will change each day to the current date, which is not what you want.
If all of the data entry is done on a form, then I suggest that you make a Dynamic Form Rule
When multiple conditions are true
All of
when [Completed] is checked
when [date completed] is blank
Action
Change the value of date completed to the current date.
and uncheck he box at the bottom
However, if you are entering data in Grid Edit mode, then Dynamic Form Rules do not apply and you would need to set up an Automation or Pipeline to do this.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
If all of the data entry is done on a form, then I suggest that you make a Dynamic Form Rule
When multiple conditions are true
All of
when [Completed] is checked
when [date completed] is blank
Action
Change the value of date completed to the current date.
and uncheck he box at the bottom
However, if you are entering data in Grid Edit mode, then Dynamic Form Rules do not apply and you would need to set up an Automation or Pipeline to do this.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- Thank you,
I have 2 fields, Completed and Completion Date. I want the Completion Date to automatically be filled to the current date when Completed is checked.
When i tried the Dynamic form rule Completion Date was not an option.
------------------------------
Fatima Khan
------------------------------- MarkShnier__YouChange the field type for Completion Date to be a Date field, not a formula date field. Then it will be available to be populated by a Dynamic Form Rule.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- Thank you,
That is exactly what I needed to do. I appreciate your help.
------------------------------
Fatima Khan
------------------------------
