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:
How do I set a date in the future and then count down the remaining days until that date? For example, my future date is 8/17/18 and each day I want it to show how many days are remaining until 8/17/18.
=[Column3]1 - TODAY()
where [Column3]1 holds the future date in question.
Nick
Nick,
Thanks for the information and that did the trick.
I am trying to create a project as a child under the parent blueprint to maintain a hierarchical structure within the workspace. However, instead of being created under the parent folder, the projects are being provisioned as separate folders at the same level.
When attempting to provision a project, the provisioning process fails with the following error: {"done":false,"logs":"Error when attempting to copy template source folder."} Show more lines As part of troubleshooting, the AI Agent recommendation to review the blueprint source folders for broken dashboards and reports was…
Good afternoon. I am trying to create an update request to have contacts in a cell complete a voting task. I have been asking the AI what the issue is and it had good suggestions, everything it suggests is occurring on the sheet. The update request is to trigger when the "Launch update request" changes to checked. It will…