-
Collect multiple project names in Portfolio Rollup?
Data is collected in this example intake sheet below and the metrics are summarized in another metrics sheet below. The following formula collects the Project ID and gives the count per associated Platform and Status. However, I need to display the Project Name as well as the count on my portfolio dashboard. How can I fix…
-
How to find the Top 5
I am trying to find the top 5 majors. I created a "helper" column as some have suggested in other posts. This column gave a number for how many people are in school for that major. Now I just need a formula to find the top majors.
-
Rollup Sheet vs Report Counts Don't Match
Hi there, I have a rollup sheet with a formula to count names based on specific criteria. I need to count items that are not decommissioned, development, stating, test, Linux, numbers 7, 2003, 2008. Unfortunately, the formula does not work. To validate, I created a report filtering the same parameters. The counts between…
-
How to flag the second largest date in a sheet
I have a sheet that collects responses from a form, specifically collecting status. I pull this data in to a second sheet to be able to show current and previous status on the same line. To do this, I am creating a helper column to flag the second largest date. I know how to find the most recent entry (largest date) using…
-
How to fix this issue i am getting with Sum and trying to add a qty based on a budget number
I want to sum a number of quantities based on a criteria that checks the budget number to the row in the purchase request sheet that has the same budget number to then add all those quantities up in a cell in the budget so this way Each budget line that is used in a purchase request the qty of how many items purchased is…
-
How do I check if something is in another sheet (& check a checkbox if it is)?
I have two sheets: a Tracker sheet & Response sheet. My Tracker sheet has a list of all the people that need to be sent a survey to complete, & my Response sheet lists all of their responses to the survey (each person's responses are in a row). Both sheets have columns with emails in them. I was planning on using…
-
Formula to obtain upcoming deadline
Hello! I am working on getting a widget on a dashboard to show the next upcoming deadline, automatically pulling this information from the below sheet, analyzing the 3 date columns. I've tried several COLLECT formulas but nothing seem to work. Any ideas?
-
Autofill Form
So if I have a purchase request form I want to select Item A, for example Once I select that, I want it to give me than a list of budget numbers to pull it out of (Item A for engineering, Item A for software, etc.) Then autofill with a set price, and I put how many I need and/or show me how many are currently budgeted for…
-
Update request for cells with cell formula
Hi Smartsheet Community, I'm trying to automate an update request for a daily form submission. The data are entered to the source sheet from the form and I've used cross-sheet formulas to pull the data in the the format needed for the document builder sheet. However, when I run a test Update Request for empty fields in the…
-
Stumped!
Trying to calculate a % for where a particular column is filled in. We have various blanks (lining up with headings) that I need to involve in the calculation. Here's my formula: =ROUND((COUNTIF([Common Control - Client Comments]:[Common Control - Client Comments],<>"")-COUNTIF([Ctrl odr]:[Ctrl odr],""))/COUNTIF([Ctrl…
