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…
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…
I have rules that remind a number of people of an upcoming end date. I want to do it two WEEKDAYS/BUSINESS DAYS in advance of the due date. The best work around I've found, is adding a "day of the week" formula field, and then making separate rules for end dates that fall on a Monday or Tuesday. Since the trigger cant be…
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? For example, the top level should be gray, the second light gray, etc. This discussion has been moved into an English category.
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…
This discussion has been merged.
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.)
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…
