-
Using RM API to balance allocation
Has any utilized API to make changes to employees allocation percentage. I am developing a script that will recognize employees across multiple projects. When it see's that they have overlapping projects it will automatically balance out their timelines. Example Dylan McCord is overallocated on 2026-02-02–2026-03-02 TRs…
-
I am the owner of my Pro account but the sheet is telling me I have View Only permissions.
This keeps happening where I will log in and for some sheets, not all, I have view only permissions even though I am the owner of the account and all the sheets. Sometimes a refresh will fix it and other times it won't. Why does this keep happening?
-
Doing a mass update of sheet reference names
I have been waiting for find/replace within formulas, but wondering if there is a different way to solve my problem. I have raw data in quarterly sheets that feed an annual sheet where the data is broken out monthly for the whole year. Every year I create a new annual sheet and have to update the formulas with the…
-
How to account for planned employee hires?
Hello all, In our Smartsheet RM instance we have a planned ERP replacement project which has a huge resource demand starting in a few months, but we plan to hire additional staff between now and then in order to balance supply and demand. However, we cannot represent the new hires in RM right now because they have not been…
-
Workaround to Copy Rows from Sheet with CR Formulas
I have the following columns in Sheet 2: A column in which I manually entered numbers (to use in a DISTINCT formula), numbers 1 to 100 A column with a DISTINCT formula that pulls distinct values from a column in Sheet 1 A column that flags if that distinct value in column 2 is already in Sheet 3 2 or 3 additional columns…
-
Multiple Licenses from different company
Hello, Im working as a consultant/developer. Im signing up with multiple clients each with their own licenses. They are adding me as I work on their project. May I know if this is possible? Will they adding me have an issue on file/sheet/workspaces view and sharing? Any tips to avoid mixing up stuff? May I know if there…
-
Project Dashboard Margins
I have a project dashboard that i like to print for meetings. When I print to a standard 8.5x11 the report does not fill up the entire page. Allow users to edit the margins of the dashboard grid. Say to 8.5 x 11 that way when they hit print it automatically fills the page
-
COUNTIFS Formula to Add Multiple Criteria from Same Column Source
Hello - I have a current formula that works, but now I need to add to it to only include the following project types in red. How do I add multiple options that align to the same criteria/source?
-
HOW TO USE A FORMULA TO POPUALTE A STATUS BAR SYMBOL
Is it possible to create a formula that will automatically populate a status symbol selection based on a percentage entered? See my current formula and sheet below: =IF(([Percent Complete]@row =1, "FULL", IF([Percent Complete]@row >=.75, "THREE-QUARTER", IF([Percent Complete]@row >= .5, "HALF", IF([Percent Complete]@row >=…
-
ERROR MESSAGE CAN NOT OPEN PROJECTS FOR 7 DAYS
I have a current paid account but smartsheets will not allow me to open my projects. for over a week, I submitted a support ticket but no one has contacted me to resolve this issue. This has caused a major backlash.