-
Conditional Formatting Across Sheets
Hi, we have a Scheduling Sheet (with columns, wk 01, wk 02, wk 03, wk 04, etc). A Delivery Date column links into this sheet from another sheet. What we do at present is highlight the relevant week column based on the date in delivery date, so for example from Jan 2nd to Jan 8th is wk 01 this year. (See screenshot…
-
When Power Automate inserts data in Smartsheet, how to work correctly with formatted columns?
I have a Microsoft Form that my sales team fills out when they win an order. I have created a Power Automate flow to create a new line in Smartsheet and insert this data. I am using MS Forms + Power Automate and not Smartsheet's form because it also performs other actions outside Smartsheet. However, on the columns that…
-
Reminder Automation based on the Forgetting Curve
I am currently working on a project where I would like to set up automated reminders based on the Ebbinghaus Forgetting Curve to maximize information retention for my team members. I plan to use the following reminder intervals: 1 day, 1 week, and 3 weeks after the initial learning event. I aim to create a system within…
-
Merged: Adding Row Links to Comment Alerts
This discussion has been merged.
-
Hierarchy automation workflow - subtasks inheriting data from parents
In the automation workflows, we need an action that will allow us to drive hierarchy related automations. The obvious one that lots of people want is to simply inherit data from parents. Using formulas in the sheet view is possible, but it's limited and very clunky. I've attached a simple image showing what I would want.…
-
Automation to fill in existing cells
I have created an automation to set the status on our tasks. My automation is based on "new row is added or changed", then meets certain critiera, then a cell value is changed to a certain status. This works for rows I add after the fact, but has not updated my existing rows. Is there a way for an automation to update any…
-
Is there a way to restrict number input to positive numbers only in a form?
I'm building an approval process/workflow for a finance team and I'm curious if there is a way to restrict number inputs to positive numbers only?
-
Condition for a workflow: created date is not in the current year
Looking for a solution to move data to another sheet with automation under condition "Created Date is not in the current year". I would appreciate if support.
-
Copy a certain columns to a new sheet as new rows are submitted
I have a master sheet that contains information submitted via a form. I am wanting to have a new sheet that contains only certain columns of information that populate as the data on the master sheet is entered. I only need specific columns of information, not every column in the row on the master sheet. Any ideas on how to…
-
Why isn't my attachment on the automated email?
Hello, I am using a smart sheet auto system where it makes the PDF automatically when someone fills out a form. Once the PDF is made I have a new one to send out an email. see below. Once they approve it is supposed to send an email with the attachment. but when i get the email back it doesn't have the attachment. Am i…