Using Modified Date in a formula returns #date Expected


Hello, I am trying to determine whether or not a row should be added to a weekly report by trying use the modified system column to calculate the associated Friday.

e.g. It's Tuesday and I make a change, I want my other column 'Report week end date' to display that upcoming Friday.

=IF(WEEKDAY(Modified@row) < 6, DATE(YEAR(Modified@row), MONTH(Modified@row), DAY(Modified@row) + (7 - WEEKDAY(Modified@row)), "Error"))

Just to see, I put "=WEEKDAY(Modified@row)" into the cell and got #DATE EXPECTED.

Can you not use Modified as a DATE type?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!