Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula help - set values for current user and date when check box checked
I have a checklist I am building for a department where they will be primarily mobile users so I would like to reduce the thumb typing as much as possible.
I see where I can use test the value of a checkbox and make it do things.. but what I want to do is get the current date and current user. So that when someone clicks the "done" checkbox, it populates the "completed on" and "completed by" columns. I dont see how to reference those values.