-
Formulas in Automations
Is it possible to create an automation that will populate a cell with a formula instead of text or a drop down value? I am trying to get a column to populate with the name of a user who checked a box. For the action block of the automation, I selected Change Cell Value in Column to =([Modified By])@row The automation…
-
Conditional Formatting for a Modified By Column
I am trying to create an automation or formula to populate a cell. Here's the gist of what I am trying to accomplish: Only when a completed box in a column is checked → I want to populate another cell in that row with the Current User who checked the box. I would like this to populate automatically through the use of a…
-
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.
-
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.
-
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?