Autofill a static date using automation


I am using a formula to compare the date created and the date due to return a green check, if not then a red 'X', but the date due column has to be a date.

The automation workflow to record the date due if a specific value in a dropdown list is selected only allows to record the current date and if I want to force a specific value that breaks the date comparison formula.

Any ideas to resolve this would be helpful.

=IF(Date@row <= [Date Due]@row, "Yes", IF(Date@row > [Date Due]@row, "No"))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!