When checkbox is TRUE then copy TODAY date in another cells and froze it

Hi everyone,

I use this formula:

=IF([Info client OK]1 = ISBOOLEAN([Info client OK]1); TODAY(); Créé@row)

Explaination: if the checkbox is checked then write the today date in the cells. this work.

My question: I would like to freeze this date because if I do not freeze it the day after it change.

I use it to make a step by step project manager by checking the checkbox when action is done. The date will allow me to have the deadline report.

Find more posts tagged with

Accepted answers

Jerome Szurubura

Hi,

Thank for your support, the automation solution give me my result

For those who want to write the date in another when the checkbox is check

1 : Click on automatisation

2: Select register a date

3: When the line is modify

4: select the checkbox column

5: select the action 'copy date' in select the column where you want to copy the date

All comments

Andrée Starå

Hi @Jerome Szurubura

I hope you're well and safe!

You could use the new Record a date feature instead.

https://help.smartsheet.com/articles/2481986-set-the-current-date-with-record-a-date-action

Another option

Please have a look at my post below with a method I developed.

More info:

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Jerome Szurubura

Hi,

Thank for your support, the automation solution give me my result

For those who want to write the date in another when the checkbox is check

1 : Click on automatisation

2: Select register a date

3: When the line is modify

4: select the checkbox column

5: select the action 'copy date' in select the column where you want to copy the date

Andrée Starå

@Jerome Szurubura

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.