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.
A long-established sheet with formula that references another sheet keeps returning a zero value. If the sheet containing the formula is refreshed, the correct data is restored temporarily but then gets reset back to zero as shown in the snip. This file is an established file and these formula have been working for years.…
A few people have filled out a form I created and its showing up as lines 14 and 15 on the sheet. Lines 1-13 are blank. Why did lines 1-13 get skipped?
I have set up an automation to send people an email to assign proposal team members once another person selects "bid". How do I get the proposal information from a line on the sheet to show up on this so the people that need to assign proposal team members have more information.
