-
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.…
-
Report Keeps Saying "Column Not Found"
I have my sheet set up and saved. Then, I created a report based on columns in the sheet. I added the following columns, saved the report. Data already in the sheet was showing in these columns. Now three times, I've opened the report, and these columns keep showing up as Columns Not Found. I unchecked the columns and…
-
Only copy certain columns to a new sheet?
I am trying to marry two sheets together, one is a new sheet for ticket intake and the other sheet has been in use by another team that has ticket information for one person but also additional information for their team. I don't want the team to have to enter in the data into the intake form in addition to their form. I…
-
Work With Flow - Operation Smile Story
Hello Community, We loved your responses on our first Work With Flow story, and now we're happy to bring you the next installment in the series! When individuals or teams Work With Flow, they work in a way that is efficient, intuitive and empowering. Rather than getting bogged down by complexities, they find rhythm. Being…
-
Using a fillable PDF as a form to fill in Smartsheet
Hello, I am looking for ways to use fillable PDF (attached) as a form to fill out Smartsheet. Similar to how a form is generated in Smartsheet, is there a way for a fillable PDF to be used as a "custom form?" Each field can be defined and mapped beforehand to the corresponding smartsheet and "submit" would update the…
-
Timeline and Gantt view on a single row
https://us.v-cdn.net/6031209/uploads/DBE28QGHXGI5/timeline-and-gantt-single-row.docx As per the attached, I would like to a single row, with color coding, to reflect the various phases of a project in Timeline view and Gantt view. The importance of this view is to give Sr Leadership and Stakeholders a simple, visual…
-
How can I find the sum using contains from a dropdown?
Hi, i have a spreadsheet that has a dropdown populated through data shuttle. In the sheet to the left there is a list of abbreviations with their corresponding points. In the sheet to the right im looking to calculate the sum of points when a user selects the abbreviations from the listing. Any ideas here?
-
Fx Help
I am in need of help to create a formula that generates a "YES" when the following conditions are met: IMP $ = 1 Million dollars or more Type = is NOT = "Cost Avoidance" or "Optimization" Act IMP Date = is a Date greater than 2/17/26 (and not blank) Status = is NOT = "Hold", "Dropped", or "Pipeline" I hope that made sense?…
-
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)
-
Wildcard to support Contians filters
During filters on numeric values that don't contain text in the string in a text/number field, the contains filter function won't pick up exact matches. Example the filter "contains" won't pick up a cell value of 12345 when contains is set to 12345 unless the cell also had text in it. If a wild card like * could be added…