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.
Is there a way you can "lock" a specific filter on by default for a sheet you publish to a dashboard? I'd like to have the sheet editable from the dashboard, but I'd like it filtered to "current user" so it can act like a one-stop shop for everyone to review the reports and update the sheet at once. I have one filter on…
Hi fellow community members, Have raised a support case for this problem, but wanted to get a feel for if anyone else in the community has experienced this (or can reproduce it): Use mobile app → open a sheet → select Mobile View (using the selector at the top) → tap into a cell → select the icon that indicates you want to…
I'm dying over here! I have tried this formula countless times and #unparesable keeps populating. I am trying to calculate thew amount of days between 2 dates. My column name is Date and Date Complete. I created another Column titled Days to Complete. This is my formula. NETWORKDAYS([Date], [Date Complete], [holidays])…
