-
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…
-
Check a box if MOST RECENTLY MODIFIED, per Hotel
Pulling my hair out! Need to check the box of the row with the most-recently-modified entry, per hotel. Not the best data set for an example but below is a screenshot of my grid. Using this formula but getting INVALID results. =IF(AND(Hotel@row = Hotel@row, Modified:Modified = MAX(Modified@row)), 1, 0) Anyone? Anyone? :)