Hello
I have a checkbox column that I want when checked to copy the shipped date form one column (Shipped Date) to another column (Customer requested date).
Is this possible with a formula?
Yes, you can enter the following formula into you customer requested date box. However, if someone hard codes a date over the formula, it will overwrite it and the formula will no longer exist.
=IF([Checkbox Column Name]@row = 1, [Shipped Date]@row, "")
Hi,
To add to Mike's excellent advice.
If you want to store the date that the checkbox was checked without adding the date manually, you can use the third-party service, Zapier, for that use case.
I hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…