nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

How to add a date based on a checkbox

sredmond

Hi,

I am trying to put a formula into a cell to say that if a check box is checked, put in the date that box was checked. I was able to do this before but it is no longer working. Is there still a way to do this?

Thanks.

Find more posts tagged with

Comments

Andrée Starå

Hi,

You can have a formula that adds today's date, but the problem is that the TODAY function will update to the current date always so it will not store the date. You'd either have to add it manually, use a third-party solution like Zapier, the Smartsheet API, or create a workaround like locking the row and similar.

Would any of those methods work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

sredmond

Can you explain the work around more with locking the row?

Andrée Starå

Sure!

If we use the automation and lock the row after the box gets checked, the Modified Date column would then fix on the date/time from that event but this only works, if there aren't any more changes, are needed for the row.

Make sense?

One other method, but it's more advanced, would be to use the third-party service, Zapier, to add the date to another column for when the box gets checked. Is that an option?

Sign in to join the conversation!

Quick Links

Trending discussions

Columns in an Excel Attachment Data Upload Auto Added to a Source Sheet
Hi, I am wondering if there is a solution for this scenario: I have a Data Shuttle data upload workflow to a Target Sheet that is updated when a new attachment is added. Question: is there a function/features/workaround like Data Shuttle, Bridge, or a combination of features so that if a new column is added to the Excel…
Do not have access to a sheet I created in another plan
I have downgraded to business but no longer have access to my sheet,i get an error 48,get licensing? How do I fix this? This is a customer contact form so i cant recreate it as the email has been sent?
No Admin Access on Sheet
I have been given access as an Admin to edit an existing sheet but cannot edit columns. I am a System Admin. I am a paid Member. I am able to edit information in the sheet but cannot add a column.