-
Dynamic Formula
Hi! I'm using smartsheets to manage my business's projects and I have an automation that triggers when my PO checkbox is ticked, so that it copies the project over to a separate client sheet. Necessary so that I can keep all of my projects for Client A, B, C etc separate, for some specific calculations I need. (Mainly…
-
How can I automate the process of giving indented lines a different color?
How can I automate the process of giving indented lines a different color? For example, the top level should be gray, the second light gray, etc. This discussion has been moved into an English category.
-
Enable Hourly, Daily, and Weekly triggers when there is custom field in the notification box
Hi Product Management Team: Goal: Send a notification once per day to an assigned individual that includes all the work items (tasks) they've been assigned. Customize the notification so it includes the assignee's name. Problem: When I insert a custom field in the notification customization box like this: Hello {{Assigned…
-
Merged: Allow to send attachments without linking to the sheet and adding other Smartsheet details
This discussion has been merged.
-
Merged: Automation/Workflow from sheet summary fields
This discussion has been merged.
-
Automation on Sheet Summary Fields
Workflow/automation based on sheet summary fields. One scenario - count of all cells, send a warning if the sheet is close to max. (Do not want helper column as that increases the count.)
-
Formula to pull the Fiscal Year from a Launch date
Hello! I'm looking to pull the Fiscal Year in a cell based on the launch date in a different cell. Our FY starts on 04/01 of the current and ends on 03/31 of the following year. I need the formula to determine if the FY is the current year, the prior year, or the next year based on the launch date. For example, 04/25/2024…
-
New copy of an old project
Hi! We have a long list of about 100 projects in a sheet - about 80 of them will be "restarting" or "renewing" this year. Instead of making the requesters fill out the intake form again, I'm hoping to save some time by copying rows from "this year's" request to "next year's" request, and just make some minor updates to the…
-
Add Reply Option in Notification Tab
It would be nice to reply to comments and conversations directly from the Smartsheet notifications tab rather than having to navigate all the way to the sheet. I propose adding a reply button next to the Go to Sheet button in the notification tab.
-
Can I create an automaton where the generated document is automatically sent?
I want to be able to generate a certificate that serves as proof of attendance that automatically goes out to the participant's email once I update their status. Is that possible?
