Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hello,
I am trying to recreate this formula from Excel into my Smartsheet:
=ROUNDDOWN((DATEDIF([@[Leave Date]],[@[Week Ending]], "d") / 7), 0)
It is supposed to subtract 7 days from the Week Ending date.
How can I make this work in Smartsheet?
try
=FLOOR(NETDAYS([Leave Date]@row, [Week Ending]@row) / 7, 1)
I have a 6 column, 10,000+ row sheet that feeds into other sheets of data through vlookup formulas, that I update on a weekly basis with new information from an outside source. the columns stay the same but the row #'s vary. is there a way I can upload the new excel version of the data to automatically upload the existing…
Is anyone else experiencing this issue today (7/28/2026)? Every time an automated email triggers on its own today, whether it's a regular alert, update request, etc, the values that usually appear when the automation workflow includes a field in curly brackets (ex: {{First Name}}) appears as a weird alphanumeric value in…
Hi - Is anyone else having problems with placeholder fields in update request automations today? I've been notified by my staff that our automations today are showing random text strings instead of the field data that they are supposed to. For example, in one of my sheets, there's an automations thatis supposed to show a…
