Today Formula

Question

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------------------------------

markshnier__you · Answer

I can help you with a formula,&nbsp; 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 RuleWhen multiple conditions are trueAll ofwhen [Completed] is checkedwhen [date completed] is blankActionChange the value of date completed to the current date.and uncheck he box at the bottomHowever, if you are entering data in Grid Edit mode, then&nbsp; 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------------------------------

fatimakhan · Answer

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__you · Answer

Change 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
------------------------------

fatimakhan · Answer

Thank you,That is exactly what I needed to do. I appreciate your help.------------------------------Fatima Khan------------------------------

Forum Discussion

Today Formula