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 need help with a challenging formula. I have the following situation: Row# Value Score Effort Score Priority Score Rank* 1 50 5 45 4 2 70 10 60 1 3 65 5 60 2 4 60 20 40 5 5 70 25 45 3 If Priority Score = Value score - Effort score then rank by priority score (with greatest priority score = rank 1) if priority score is…
Hello - I am trying to set up some Summary Fields and the formulas needed are a bit above my skillset. I use the AI assist to generate a formula, but I cannot figure out how to add to Summary fields rather than to a specific cell on the Sheet. Also, I am getting error messages on formulas that seem logical and pretty…
Please see my formula below - it has been working correctly i believe until i finally had something go past due. Instead of just showing -1 it shows as -3? Can someone help me fix my formula?
