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; } } }

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

"Fields marked with an asterisk (*) are required." line on every form.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
Dynamic View Issue - Group Sharing
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…