-
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…
-
Employee Reviews - Averaging scores for different criterea
Been playing around with a few index/match formulas but getting a bit complicated..🤯 To explain: Need to add numeric values to each dropdown to give scores to each critera Then search for each Reviewer that reviewed each employee and add all scores for each critera Finally, average the score =AVG(CHILDREN()) Went ahead and…
-
Red Yellow Green Gray
Hi Experts :), I need help with my formula. Principles I am trying to achieve are: if Min Variance column is blank AND the Minister Due Date is past today by less than 2 days, OR the Min Variance@row is Less than 2, then flag Yellow. If the Min Variance column is blank, AND the Minister Due Date is past today by more than…
-
AverageIF
I am trying to get the average number of days to fill a position, the formula I am using is pulling data from my worksheet for the Position type, date range, and days to fill. With my formula below I am getting an Incorrect Argument. I think it has to do with the bolded portion of the formula. =AVERAGEIF({Time to Fill -…