-
Sync Client between Smartsheet Project Sheet and Resource Management
Hello, Currently we are using Smartsheet and its integration with Resource Management. Projects are created in Smartsheet with a defined template and then they're imported on Resource Management. When the project is created in the first system, a lot of information are entered there, such as the Client. It would be very…
-
Formula Help for Allocation % of work week based on employment type
Hi - I'm trying to figure out if I can put an automated column into Smartsheet. I think that I might need to use a couple formulas, maybe in multiple columns, but for the life of me I just can't figure out how to make it work. My manager asked me to list out percent of workweek allocation, based on different work types. I…
-
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…
