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.
Hi ! I am trying to figure out why some email notifications include attachments and others don't. I have a few teammates who add attachments to the rows when certain columns are triggered by a checkbox. I have my automations set below. And you can see once column was checked email includes attachment, but same email it…
I am trying to import (just blank rows, with 18 columns) from Excel into an existing sheet, so I don't have to recreate the 18 columns into my tracker. But I get a "Failed to Import" error. HELP!
I have three columns. One with a date 7/1/2027 in date format. One with a number representing the number of months I wish to subtract from the date column. Third column is a date column with the following equation: =DATE(YEAR([Column4]@row) - INT((MONTH([Column4]@row) - VALUE(Factor1)) / 12), MOD(MONTH([Column4]@row) -…