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 f…
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. U…
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…
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…
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 su…
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…
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 s…
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 dat…
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([Comm…
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 bu…