If a checkbox

Hello again.

I need some help please with automation/formula on a project management sheet we use.

(Action 1) I have a checkbox column called "SNAGS"

When this is checked, I need a date column called "SNAG ADDED" to auto populate the date in which the checkbox was ticked by the project manager.

(Action 2) Like wise, I have another checkbox column called "SNAG COMPLETE", I want another date column called "SNAG CLOSED" to auto populate with the day the checkbox was ticked

(Action 3) Next to the date columns "SNAG ADDED" and "SNAG COMPLETE.

I have a column "SNAG DAYS TAKEN". I need this to auto populate the number of days difference between the two columns, so we can see the number of days taken to close a snag our from it being raised to being closed.

Appreciate explanations/ formulas in layman terms if possible. I'm based within the UK if this helps.

Thanks in advance.

Stuart

****On a side note, Is it possible for text inputs from one sheet- to automatically replicate and copy onto another sheet without having to copy & paste or even enter the other sheet you'd like to mirror information onto?

Image 1.PNG

Image 2.PNG

Find more posts tagged with

Construction

Formulas

IT & Operations

Conditional Formatting

Project Management

Comments

Paul Newcome

Smartsheet does not currently provide timestamp capabilities for specific actions outside of the Created and Modified type of columns.

The best way to do this would be to do away with the checkboxes, manually add the dates and then use a basic =[Finish Date]@row - [Start Date]@row type of formula to calculate the days it took.

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…