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.
Sign in to join the conversation:
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
Hi everyone! I have a list of report dates that I want to be notified on, but am having trouble getting this set up. My thought process was to create a column with =TODAY() in the first cell, and then set up automations to be alerted when "Today" equals the "Report Date". My issue is that two are different formats. The…
Currently below is what Smartsheet allows for Group management. In our organization, this is very restrictive as it only allows 3 people to manage groups that required a lot of maintenance. Allows Group Admins this ability would make it much more flexible for large organizations who have multiple individuals with the…
Hi All i am trying to determine the stage that a project should have readhed by today, based on a series of milestone dates across the row however, in this particular example i am getting #invalid operation which may be due to the blanks. they are blanks because they currently have no date which is probably a flaw in the…
