-
MAXIFs Alternative?
I have a google form that updates the prices of materials. On google sheets to display the most updated price of the material I have a Newest Entry Column =MAXIFS(Timestamp:range, Material cell) then in the material price columns I have an Index/Match formula to display the most recent entry for that material. I would like…
-
License for Update Comments?
Hi! We have a project management team that has created a very thorough tracker through smartsheet so most meetings are very quick and to the point as it is but, I was wondering if we could be even more efficient if I have people that are completing the individual tasks comment on the line item to give their update ahead of…
-
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…
-
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.
-
Tracking & Reporting on Project Hygiene
Hi All! I am starting to explore the possibility of tracking the "hygiene" of each project being managed by our team. We have a control center solution so the artifacts all of us on the team are consistent/templatized and capable of collecting data for a rolled-up portfolio view. So I'd like to be able to leverage that to…
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
Impossible to set a Date Constraint (Blue Anchor) - Predecessor is being deleted instead
Hello,I'm struggling with date constraints on child rows. Setup: Dependencies are Enabled. I have a standard Parent/Child hierarchy. I want a child row to have a Predecessor but also a "Start no earlier than" date (manual constraint). The Issue: Every time I manually enter a Start Date on a child row that already has a…
-
Error message when opening my project : Une erreur est survenue dans SmartSheet
when i try to pen my project, the message below appear, i don't know what to do. My collegue has the same issue. I tryed on another browser, or computer. it was the same
-
Resource Management Calculation
Summary of Issue All team members work a standard 7.5‑hour day, but only a portion of that day is allocated for project work (e.g., 25%, 50%, etc.). In Resource Management, however, the system currently interprets allocations as a percentage of the full 7.5 hours, instead of the project‑eligible portion of a person’s day.…
-
How to recover deleted calendar from Calendar App?
My colleague accidentally deleted a calendar I created in the Calendar App that our team shares. How can I recover this? It's not in our deleted items. I do have the URL, currently seeing this error: Oops! The page you were looking for doesn't exist. (ErrorCode: 404)