-
Looking for a cell value to trigger a formula
I'm looking for a formula to reference the value in a column then run a formula. I am using this to check the status of a contract then run a formula to see if too much time has passed in that status. If contract status is "In Legal" look at date sent to legal and make the value expired if seven days have past.…
-
Visual indication of child rows when mouse hovers over the +/- icon of a parent task
Use case in mind: Working within a complex project plan containing lots of hierarchy. (Possibly with outdated and messy content...not all of us PM's are perfect =/) Having to open and close parent tasks often as you build out or make large structural updates to a plan. Opening and closing a parent task can be a bit…
-
Trying to connect Acumatica to Smartsheets
I keep getting an error and cannot find any explaination anywhere. There error says Unable to parse request. The following error occurred: Field "value" was not parsable. value must be a primitive type at [Source: java.io.PushbackInputStream@318c0afb; line: 1, column: 1012]. Could someone explain what I am doing wrong
-
Size and format of PDF exports/prints
Hello, everybody, We have been using Smartsheet for some time and love this tool (changed from MS Project). However, the PDF export is not adequate for the rest of the tool. It seems that Smartsheet can only export/print PDFs as images, not as vectorized PDF. As a result, the file size of the generated PDFs is simply too…
-
Data Mesh scheduling - new row in the target sheet
I have a configuration with Execution Frequency = Immediate and Data Mapping Format = Create Cell Links. When I add a new row to the target sheet, mapped cells do not get their link in the new row. If I change the schedule to 1 Hour, links are added. Q: If all my mapping is Create Cell Links, then I don't need a frequency…
-
How to list values in a cell based on another cell with distinct names (in a list format too)
Hi, We are trying to present the labor hours workers have dedicated to one same task on different instances. We started by nesting =JOIN(DISTINCT(COLLECT({Worker}, {Task}, "DC6-" + [Task Label]@row), ", "), ", ") We have successfully filtered a list of workers that have dedicated hours to a task. We would then want to…
-
I want a formula that specifies the lowest child of an ancestor, parent, child hierarchy.
I am using the Hierarchy formula, =COUNT(ANCESTORS()), to label my project tasks. A lot of the child tasks have tasks below that, going to a hierarchy of 5. I want to create metrics sheet that shows the estimated completion date for the lowest level child. Because the levels vary by task, I cannot choose a specific…
-
Sub-Projects within a Larger Project within a Portfolio
We have various distinct teams (Business Development, Engineering, Production/manufacturing, field installation), and we think it best we develop and maintain our projects separately. However, we still have the need they roll up into a parent project, which may in turn roll up into a portfolio. I believe this can be done,…
-
Dashboard Chart Widget Vertical Axis Numbering
So, I have added a few new charts to an old dashboard, and for some reason the new charts are adding a decimal and two zeros to my vertical axis numbers. It isn't the end of the world if the numbers look like this: 5.00, 10.00, etc. But, I would prefer that they simply be whole numbers. In previous charts I have created…
-
Combining IF/AND/OR to return a value when multiple criteria are met
Hi Everyone, I am trying to filter out tasks on my Gantt chart occurring over the next three weeks. We found a good combination of filters that works for reports, however I want to be able to create a filter like this for the sheet so that the tasks can easily be edited in real time. Sheets do not allow for the hierarchies…
