Is there a formula or other way to have a column display the date that a checkbox was checked?

CLH707 ✭✭

06/08/23 in Formulas and Functions

Is There A Formula or Other Way to have a column display the date that a checkbox was checked? I'm also wondering if the user who checked the box could also be displayed in a column?

Tags:

• Formulas
• functionality

0 · Share on FacebookShare on Twitter

Best Answer

• 

  Autumn Beauchamp ✭✭✭

  06/08/23 Answer ✓

  You should be able to do that in automation. There is a template called "Record the date when specified criteria are met" and if you use that, you can record a date when a the checkbox field is checked.

  1 · Share on FacebookShare on Twitter

Answers

• 

  Autumn Beauchamp ✭✭✭

  06/08/23 Answer ✓

  You should be able to do that in automation. There is a template called "Record the date when specified criteria are met" and if you use that, you can record a date when a the checkbox field is checked.

  1 · Share on FacebookShare on Twitter
• 

  CLH707 ✭✭

  06/08/23

  https://community.smartsheet.com/discussion/comment/379718#Comment_379718

  Great! That worked perfectly, thank you for your help!

  0 · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list