-
Formula based on last modified date that skips weekends
Hi there, I'm building out a new sheet where I utilizing the system's "Last Modified" date column. I tried to trigger a workflow off of this column that sends an update reminder if it hasn't been modified in 2 days, but the column is not showing up as an option (presumably because it's system generated). With that in mind,…
-
Self-Update Solution - Enabling [outside] users to edit previously submitted content
If you host a set of records that "belong" to others, and you want them to be able to edit their records at any time, check out this dashboard as a seedbed of ideas for how you could achieve this. Please suggest other wording I could edit into in this title or entry to help people find this. I'm doubtful "self-update" is…
-
Merged: Gantt Timescale Settings
This discussion has been merged.
-
Enable Workspace Modification
Allow an Admin to modify the sidebars (e.g. Browse, Workspace Shared To) to accommodate better visibility to the main space. This should be a simple "Hide" or "Move" the bar to the left or right. The current structure makes the workspace less than optimal.
-
User doesn't receive workflow notifications
I´m trying to figure out why one user can't receive email notifications from smartsheet. Context: I have a smarthseet to track QA Auduts and this specific workflow is to send the audited agents an update requesting to sign off their results. Due the nature of data in the sheet, Agents don't have access, so once the QA…
-
Automation of Update Requests
My team each has a sheet on which they need to ask faculty preferences. I have built out an automation to send the request. When it sends, it sends the request for all the rows, not just select ones. However, testing the automation allows me to select which rows I want to send. How do I build this into the automation?
-
Send upbatched workflow update requests OR allow saving of each request separately
The inability to send unbatched update requests is something our org needs. Right now I can't send a workflow on a daily basis requesting a cell update because I need to include a placeholder. Putting those tags in the email would prevent batching, but also prevents me from running the workflow on anything except "when…
-
Recurring Workflows - configure a workflow with a time-based trigger
Hi All, Great news! I just got a message that Recurring Workflows are coming soon. Customers have requested the ability to set up workflows that repeat on a regular schedule. We're preparing recurrence for time-based workflows so you can save even more time on repetitive steps, such as daily due date reminders and weekly…
-
Automated Email Format / Content
Hi there, I’m working on an automated email that I need to go to stakeholders once per month and cannot get to work. In short, I want a monthly series of emails to go out from a sheet. It should be one email per customer’s data rows, but the email goes directly to the salesperson (Contact column) and has *all* rows for…
-
Subtract scheduled "Leave" hours from available hours to make utilization more accurate
Currently, leave hours scheduled are not subtracted from available hours. This skews the utilization calculation which is critical to our company's metrics. It is impractical to modify each user's profile for available hours every time a leave is scheduled. This should be an automatic calculation, or at least an admin…