-
Move a Dashboard to a New Workspace
Hi - I need assistance with moving an existing Dashboard to a different workspace because people outside of the original workspace need access to it. It was filed under a few folders under workspaces and it got moved to "Sheets" general folder and now some of the connections don't work. Is there a way to leave it where it…
-
AMI Estimator Formula
Hello! Has anyone set up a formula in Smartsheet to calculate the Area Media Income (AMI) Percent? I would like to enter an amount into a row and set up a formula that calculates what percentage of AMI an applicant is. I think it would be a long formula that might include all the different amounts of AMI income. Thank you…
-
Automation
Hi everyone, I need to delete duplicate rows in a sheet. How can I create an automation to delete one of the "n" duplicate rows? How can I create an automation that deletes a row completely under specific conditions? Also, is it possible to highlight duplicate rows with conditional formatting? Thank you!
-
Organize the returned value JOIN + COLLECT (?)
Hi guys, could you help me with a case? I don't know if it's possible, but is there any possibility of organizing the values returned to the cell in such a way that, starting with a symbol, the rest is organized right below, as in the next paragraph of the cell ? I'm saying this because with the combination of JOIN +…
-
How do I create one sheet that automatically ingests data from other sheets?
Howdy community! I have about 90 different project plan sheets that there are static cells I'd like to pull information in from. Those I have already created on a different sheet by using a cell reference. Easy enough. My struggle now is there is a separate sheet for all 90 of those projects that contains status updates.…
-
Populate Drop Down Lists using the members of Group
Hello -it would be great to be able to use a group already established in SmartSheet to fill/populate a drop list for a data point. Example - we have a SS group created for 40 project managers, I would like to type the name of the group in the drop down and the 40 names populate in the drop down list without having to type…
-
When will increase in cell limits be implemented?
I attended last year's Smartsheet Engage and there was a big announcement that Smartsheet would be increasing cell maximums in sheets - from 500,000 to 5 million. Any more word on that? When will these new cell limits be implemented? I have several big projects I'm holding off on until the increase happens.
-
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…
