-
Using placeholders for Row Number
Hi there, I'm looking to be able use a place holder in an update request to provide the person receiving with the correct row number/ID. They will need this to engage an API connection back from a form. Would you be able to provide the placeholder needed to pass this value through in the email to the user? Thanks Dean
-
Smartsheets - Machine Learning or other solutions
I'm working on a large smartsheet log that intakes customer information. I am wondering if Smartsheet can do the following using AI/machine learning: Users Update cell, Read cell, Interpret cell, and automatically insert the appropriate option from a drop down menu based on what is interpreted. It needs to be able to learn…
-
Font size on gantt chart
When printing a gantt chart I'm able to increase the text in the columns to make it a reasonable size for printing, but even at the largest setting of 36, the text at the side of the task bars, plus the task bars themselves stay very small. Is there any way to increase the size of these too ? Thanks in advance for any help.
-
Copy row from sheet to workspace
I'm working on automating the process of copying a row from a sheet where I have administrative privileges to a sheet within a workspace where I am the owner. The owner of the source sheet, which I am copying from, has admin access to the destination sheet but is not affiliated at the workspace level. When creating the…
-
3 Row Limit for workflow notification to slack
I've set up an automation to send a slack notification when a date is reached on a sheet. Typically there are only 2-3 rows that trigger this on a daily basis. However when more than 3 are triggered, the slack notification only shows the first 3 rows and then indicates there is 1 other row but no further info. Is there a…
-
Can multiple people fill out different areas of the same form
I would like to have a form which is initiated by one person. This would trigger the next person to complete their portion, which would then trigger the next person to fill out their information. Preferably, I would like only the fields each group/person needs to fill up to be visible. Is this a possibility?
-
Filter rows under parent row?
Good afternoon, I was wondering if it was possible to filter rows submitted by a form depending on a priority. For example I have 3 parent Rows that are High, Medium, and Low priority. If a new issue is submitted via the form for a High Priority. Have it automatically sort under the High Priority Parent Row? As of right…
-
Project Analysis
Hello I would like to create a SS that analyses projects, during and at the end of. I require $ analysis. Can anyone suggest a pre existing sheet?
-
Automation Question
Hello, I am new to smartsheets and I'm trying to use the automation tool to auto-populate some of the information on my sheet so it doesn't have to be filled in manually but it doesn't seem to want to work. I have an interview tracker and what I want to do is if I select "No Show" under the attendance column that it…
-
Broken roll-up calculation when using hour durations for sub-tasks?
I have a parent task called Foo and two sub-tasks, Bar and Bie. When I enter 1h as the duration for both sub-tasks, the roll-up duration calculation for Foo shows 1.125d. I'm actually seeing this throughout my sheet with another instance having 4 sub-tasks add up to 5h but the parent shows 0.375d. I've made sure the length…