-
How to get an average of multiple symbols (harvey balls) on a single row?
Hi, I have a form that once completed populates a sheet. The form has about 100 items. The idea is that 100 items represent 5 categories. For each individual that completes the form I need to provide an average from the 100 responses that correlate to each category. I have the columns next to each so I can use the "range"…
-
Find most recent updated status for category
Hi all, I'm searching for a solution on following idea: I have a sheet with following four columns: Created (date) | Category (Dropdown) | Previous Status (RYG balls) | Current Status (RYG balls) Now I want to auto-populate "Previous Status" with the last "Current Status" of the same "Category" when a new row is entered.…
-
How do I get the % to stay at 100% and not 150%?
How can I get the Completion Rate to only show 100% rather than 150%?
-
Multiplying Cells in an IF statement
Morning Smartsheeters.. Was hoping someone could shed some light on why this statement isn't working.. =IF(Part75 = "Labour", [Supply Price]75 * [Quantity]75) I'm trying to multiply two cells based on whether the labour cost is Labour, or Labour O/T.. but I'm getting an INVALID OPERATION FAILURE. Thank you.
-
Auto-assign contact based on department within a form
Hello! I have a form for project intake work where the end user has the option to specify in which department they feel their project should reside (for example, DBA versus Phones/Communications, etc.). I'd love to use INDEX/MATCH to auto-assign a PM based on what that department is e.g., DBA = Johnny Appleseed,…
-
COUNTIFS Formula referencing a single cell value as a criteria
I have built a calendar for tracking communications sent by my team, and I am trying to use that sheet to create a dashboard from which we can easily see how many comms of each type we've sent out within a quarter, both current quarter and the previous one. Our fiscal calendar follows a 13 week structure, so it's not…
-
Search for condition across multiple columns if date range is met
Hi, I am trying to insert a formula that looks into my master sheet to find the word "3-MEETS STANDARDS" across 12 columns and when this condition falls between a date range (1st Jul - 15th Jul). I used the formula below and ended up getting a #UNPARSEABLE error. I can't seem to understand where I am going wrong so any…
-
Is there a way or alternative way in referencing a formula from the Report?
Hi, I have a huge data in my sheet which is automatically fetching data from a google sheet. And to summarize my data to which I need, I am planning to use a Report but when I am computing for a COUNTIF, I have realized that the we can't reference a formula from the Report yet. Is there a new feature to convert Report into…
-
formulas not copying down
I run into issues with my sheets where the formulas do not copy down when new rows are entered. I understand that the new row cannot be blank and have clarified that to the users, but this is going to be a recurring maintenance issue. I have a fairly simple build where I am tracking billable time for a team. We are…
-
Automated Workflows and Charting Are Very Powerful
My Smartsheet application is going on six years old now and was in need of a rewrite after years of incremental improvements that used newly available capabilities in Smartsheet and as the needs of my company changed. My application basically takes project timekeeping data from an internally developed app via the…