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

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 Community Champion

03/24/20

What is the exact relation you want it to have?

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Would you benefit from getting my help in person?
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

Extracting all text from a cell to the right of a symbol
Hi, I'm trying to extract all text from a cell after the hyphen "-" symbol. There may be a long text string after the hyphen, not a set number of characters. I can get it to extract words to the left of the hyphen using the LEFT function but when I try to use RIGHT it cuts off part of the text? Top row formula in Short…
Is there a way to make a field in a form auto populate street address as its being entered?
I have a shipping management Smartsheet that has a intake form with a address field. When users fill in the address field sometimes they do not provide the entire address. I want the address to auto populate as they type in their address.
IF formula for INDEX/MATCH across sheets
Hi, I'm really struggling with this one. I have a sheet that has a drop-down with options for "Yes" and "No" and I want to perform an INDEX/MATCH function based on another cell in that row, but only if the result of the drop-down in that row is Yes. The sheet reference for the Yes/No drop down is {App_S}, and the two cells…