-
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?
-
history of automation to 'alert someone'
Is there a 'sent' list/history of the 'alert someone' automations for a sheet? From what I can see, this information is not in the Activity Log. Thank you!
-
Copy auto number field to another field in the same sheet
I want to send data from an Auto-number field in Smartsheet to Salesforce, since it is a read-only field it is not possible so as a workaround I want to copy Auto-number field data to a 'text field in the same sheet (which I should be able to map it to Salesforce fields). I can use a ( =[Column]@row ) formula to copy…
