How do I set up a 'running date column'?

Options

Tiffany Sherrane

Tiffany Sherrane ✭✭

03/24/20 in Formulas and Functions

Similarly to a running total, I am needing to have a running date. So that every day it will move and change based on 'today'-- and referencing my start date column. How do I set this up?

Tags:

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

03/24/20
Options
What is the exact relation you want it to have?

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

% Complete is Incorrect
In project settings I have dependencies enabled. This auto calculates % complete; however, the. percentage is incorrect. In my example I have 2 Parent rows, each with 5 tasks. Everything under Parent 1 is complete and everything under Parent 2 is not started. The % complete should be 50%; however it shows 43% complete. I…
Index-Match cross-sheet reference for a Contact List column
Hello everyone - thank you for your help. I am having some challenges with an Index/Match formula that populates a Contact List type column from a cross-sheet reference. It is finding the data & pulling it back, but it is not formatting the column as a "contact" - it looks like plain text (no contact "circle") This is my…
Reference sheet CountIf Contains
Hello, I am trying to build a reference sheet that gives a summary of quarterly results. I need to count the row if the value contains either Exception or Samples. I tried many different versions only getting many different error messages. This is my last attempt getting a Invalid Operation. =COUNTIF({2023 Q4 Monitoring},…