if checkbox

HI,

If a checkbox is selected in column "SNAGS" can another column "DATE RECORDED" automatically populate the date in which the checkbox field was selected?

Regards

Stuart

Find more posts tagged with

Formulas

Project Management

Comments

Lee Joramo

Try this:

=IF(SNAGS1 = true, TODAY(), "")

If you uncheck the box, the date will be cleared.

Andrée Starå

Unfortunately, that won't probably work because the TODAY will update to the present day.

The only way that I can see that it would work will be if you change the date manually to the date on that day.

Best,

Andrée

Andrée Starå

Hi again Stuart,

It's possible to set up with the help of a service like Zapier, Azuqua or similar. Depending on your specific use case the question is if it's worth it.

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Sign in to join the conversation!

Quick Links

Trending discussions

Workflow Generate Impact Report PDF in Impact Form Response Sheet has become invalid
Hi All, I keep getting this annoying error when I try to trigger a PDF generation. I initially set up to trigger the PDF generation to kick off once the last field the needs data is "not blank". That is when the error started. I modified the sheet and added a yes/no drop down to trigger the PDF generation when the value in…
Dashboard not updating
Hello Smartsheet Community! I created a formula that tracks the number of days away from the deadline that I posted on my dashboard as a visual for my students. =IF([Deadline Date]@row < TODAY(), "🔴 Past Due (" + ABS([Deadline Date]@row - TODAY()) + " days ago)", IF([Deadline Date]@row = TODAY(), "🟠 Due Today",…
Sheet Summary Formula Help
Hello, I am trying to get this formula to work but am not having any luck. When I remove the last @cell….text below the formula works great. When I add it in I get an error. Any ideas? =COUNTIFS([ACCT READINESS STATUS PLV]:[ACCT READINESS STATUS PLV], OR(@cell = "PENDING LOCAL CAH", @cell = "ADDITIONAL REVIEW NEEDED LOCAL…