Help automate the field update in formula so that my summary is always showing the most recent data

I am currently doing some simple data entry in Smartsheet for my company. I am fairly new to Smartsheet and I am still working on my skills in Excel. For one of my sheet summaries, I am using the formula

=SUMIF(Date:Date, ="07/14/20", [COLUMN NAME]:[COLUMN NAME])

to sum the data in [COLUMN NAME] based on the current date. I do daily updates and so every day that I do my updates, I have to go into my formula and manually change the date so that it lines up with the most recent date. Is there anyway for me to automate this so that the formula always uses the date from row 1 in the Date column?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!