-
transfer profile to personal email address
I found out yesterday that Medtronic will not be renewing my contract, as per legal there is a 2 year max on contracts. So I need to transfer my Medtronic Community profile to my personal (free account) I created. Now I bookmarked the link below from before. However I was unaware of what the timeline involved was. Like…
-
Smartsheet User Names - Resource Management - Temp Contractors
Hello - We have one constant email address that gets used by a few people for specific projects, so it's not always the same person. Contract employees - not permanent. I was told that my recurring error in Smartsheet not syncing to Resource Management is due to inconsistent naming within the sheet to RM. What's suggested…
-
Form Response getting captured from row 49 not from from top row
I have created a smartsheet form. While testing it, once I fill up the form, it's response is getting captured from row 49 in my smartsheet (I want this to be captured from row1 itself and other response on row 2 and so on...), I have looked for solutions on the community but could not find anything related to it. Can…
-
Move Row/Copy Row Automation flowchart
Hi Smartsheet, I'd like to have a high-level Smartsheet view that shows, in a visual, the "Move Row" and "Copy Row" automations from one sheet to another. This would be extremely handy when communicating to management or onboarding new employees to existing Smartsheet processes. Additionally links directly to the sheet on…
-
Reply box is collapsing / disappearing when replying with '@' character
My reply collpase after the Date@row - it just collapse and I am having hard time adding anything at the end.
-
Counting name and flag in another sheet
Hi, I have a sheet that lists Muppets and a traffic light flag. In a sheet I'll use for dashboard matrix info, I want to count how many times each Muppet has each colour of flag. Each Muppet is listed in a column called Metric. My countifs formula is returning a value of 0 when I know that Ms Piggy has one red flag (for…
-
Traffic Light based on multiple-select drop-down in next column
Hi, I would like to automate my traffic light (here called Overall Assessment) based on the count of options selected in Potential Impediments. It is possible to select 0-5 items at any one time. Would the best option be to have a hidden column that counts the selection and use that as a reference point for the traffic…
-
Sharing form link without providing edit or read-only access to underlying Smartsheet
Hello, If I create a form that I want other departments to fill out when submitting an analysis request to my team, is there a way to make it so they can't see the underlying/source sheet? The sheet the form is tied to contains all of our project data and doesn't need to be visible to those outside our department. Thanks.
-
Bridge: Google Translate with support for array translation
Hi, I was doing work for one of our clients where I hit a system / feature limit: Task: Translate 500 rows of text in a sheet into another language and write back in another column within the same sheet. Limitation: Google Translate module can't accept an array as input. For this reason, the translation task has to be…
-
Repeated Task
Hello all you wonderful SmartSheet users I am trying to find a way to represent a repeated task and the associated information (Start /finish Dates, Status, % complete) from the first time this task is completed. i.e. I have a drawing and its associated sub tasks. This drawing is a sub-task in a later drawing. As such, I…