-
Smartsheet Core Product Certification for a new user?
My organization is asking that I get Smartsheet Core Product certified- I've used it a little in my previous role, but have a lot to learn. What courses would you recommend to get certified in a short amount of time? I'm looking at a few paths but unsure what the differences are, and ultimately which path to choose-…
-
Auto populate in multiple blank rows when a another cell dropdown is changed?
Hello and thank you I have a sheet that has specific milestones to be met based on each selected project size option. I am hoping to automatically shows those milestones based on the size selected in a drop down for the next blank rows. For example: "Small" has 3 milestones , "medium" has 6 milestones, "large" has 10…
-
Forms - Hyperlink in help text of questions - How to open in a new tab?
I created a survey in forms, and I have several questions where I would like to have the user be able to click on a hyperlink within the help text section to get more information. However, any hyperlink I add does not open in a new tab. And the user loses any inputs they have already put into the form. When in edit mode,…
-
Can you combine approval requests from multiple rows in one email?
I am working on a project that would automate weekly emails to request approvals. I set a condition to automate which rows are sent for approval, but Smartsheet sends the approver a separate email for each row. Is it possible in Smartsheet to combine all the approval requests for all the rows that need approval into only…
-
Does wrapping text in a column or cell affect the view of others shared to the sheet?
I have some automation linked to a sheet from SalesForce that I know affects the sort of a shared sheet, but I'm not sure if that is the reason some columns are getting wrapped in my view, or if it's just another user. Same question but for column expanding as well.
-
Rounding Summary Numbers in Reports
We have reports that show us turnaround times for certain items. We are using the summarize feature to take an average for those turnaround times, but the decimals do not come out cleanly or consistently. Is there a way to round these averages so that it is a whole number?
-
New Update Request 'button' not able to be read
Hi, With the recently release to be able to send a recipient an update request that lists the specific item and allows them to open the request, the 'Open Request' button/link is very difficult to read as it's blue text in a blue box. Is there a way for me to adjust this?
-
How do I email a central database of contacts?
Hi Everyone, I have two separate sheets. Sheet 1 is a database of all my different suppliers, which has their name, email, and specific item which they supply. Sheet 2 is where I specify what item I would like to procure at a certain time. Once I specify the item I want to procure in sheet 2, How do I automate an email to…
-
Conditional Formatting - Set Condition
Hello, My smartsheet is long and has many columns from which to choose, against which to apply a condition. As I try to move down the list, to select the appropriate column, all the text starts vibrating and won't stop. I am unable to set the condition. I have had this problem for quite a while now. Could you please…
-
Dropdown menu not working - using predictive text
Hi there, I have a new problem that cropped up in the last few days. I have a dropdown list column that has worked perfectly up until now. One of the choices in the dropdown is "Accepted" and in the past I would start to type "acc" and <Enter> and it would automatically choose "Accepted". However, now it uses predictive…
