Date Formula



We are trying to report on the data at the end of each week. Each individual fills in the form each day. What I want to be able to do is total their information every Friday and report the Friday date. So if they enter in today's date, 01/25/2024, I want the helper column to return 01/26/24, however I am receiving "#INVALID COLUMN VALUE." What am I doing wrong?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!