-
Automation - Sheet Update based on Criteria
Hello again Like a typical N00B I'm having wonderful ideas with almost no knowledge of the product (go easy, I'm just rolling into my 5th hour in 2 days of using it) I wanted to know if anyone has any experience or thoughts on how best to approach this scenario as I've found some challenges with my current workflow…
-
Approval Workflow - Don't Show Previous Comments
I am configuring an approval workflow where the approval request is being sent to a client contact. As part of the approval process I would like to give the client the ability to upload attachments and add a comment if desired. Since there could be existing attachments/comments that I would not want the client to see I do…
-
Alert Someone Automation - Reference Contact In Summary Field
When configuring an Alert Someone workflow and selecting "send to contacts in a cell", is it possible to reference a contact in a Sheet Summary field for the sheet? The drop down selection only shows contacts columns within the body of the sheet.
-
Can I setup conditional formatting based on a time function?
Hello! Is it possible to setup conditional formatting based on a time function? For example, I want a cell to turn red if it hasn't been updated by 12noon. Or, I want a cell to turn red if the current time is after 2pm.
-
Blank Automation Notifications
Hello, I have a number of automated workflows setup using Dynamic Cell Data in the subject lines and message bodies. This morning I was informed that some received message with blanks were the Dynamic Cell Data should have been. Has anyone experienced this issue before? No columns had been adjusted prior to cell changes.…
-
Repeating # formula
this is what i have - but not working IF([row #]18, =1, "2", OR(IF([row #]18, =2, "3", OR(IF([row #]18, =3, "4", OR(IF([row #]18, =4, "5", OR(IF([row #]18, =5, "6", OR(IF([row #]18, =6, "7", OR(IF([row #]18, =7, "8", OR(IF([row #]18, =8, "9", OR(IF([row #]18, =9, "1", i want if the row above is a 1, the next row to equal 2…
-
Approval Process Workflow
Hi, I would like to have an approval process like on the example below. However, on Item B needs to be approve first by Approver 1 before Approver 2. Please advise if it possible on the same column on the Approval Status.
-
Incorrect field value in email with Smartsheet automation
Hi, I see an issue in automated email if we use a Date column with formulas. In my sheet, I have a Date type column (CreatedDateTime) with formula =Created@row+"". So, When a row is added, this cell shows the Date and time based on timezone selected in Account->Personal Settings. e.g. 06/23/21 6:27 PM I am in GMT+5:30…
-
Counting checkbox's for children without counting the parent
OK I am new to building formulas like this and everything I keep trying gives me errors like "UNPARSEABLE" and "BLOCKED". How would I set up a formula for this? If the "Is there a color image?" box then the row will be counted. My goal is to have a total count of images that we have a color version for. the URL is on a row…
-
Auto- Number based on Parent child relationship
I want to auot number based on the parent . i.e if I have a number items (Parents) I want these to be auto numbered but any item below them, indented to be for example 1.1, 1.2, 1.3 etc. on the first parent level of indent and the next similar 2.1, 2.2, etc. Any idea to automate this?
