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:
I'm trying to find a pattern as to how the numbers are generated when two modified by cells are subtracted from each other. At first I thought it was in minutes and separated via location in the number, but upon testing that proved to be incorrect.
Does anyone know how to translate the number that is given when two modified by columns are subtracted from a decimal to something useable?
https://app.smartsheet.com/b/publish?EQBCT=c8ad7111f9da4fb3a160d2cbf25d33eb
Hello,
Looks like your sheet has been unpublished.
Subtracting two "Modified by" date columns provides you with a duration in days in the form of a decimal value.
NOTE: The time component is ignored in this calculation, only the difference between the date values is taken.
How do I see who submitted a form for a specific sheet?
Hi, I have a Gantt covering 500+ rows of events past and planned. I use it to predict and track values around these events. Using helper columns to identify the current week, I get an email report on a Monday that tells me the upcoming events in the current week (7 days) and their values. Currently if an event spans…
Hi Smartsheet Community, I'm working on an action management system where users create sub-actions through a Smartsheet Form. The requirement is simple: a sub-action's due date must be earlier than or equal to its parent action's due date. For example, if the parent action is due on June 30, 2027, users should not be able…
