-
Cross-sheet & condition-based formula
Hi all! I need a formula that imports a reference number (auto-generated) from a column in sheet A (source) into a column in a separate Sheet B (destination), but only when a separate drop-down column in Sheet A changes to a specific value. Using a filtered report in lieu of Sheet B is not an option (at least not…
-
Which Index formula should I use to cross reference multiple columns?
I have a sheet that includes 5-6 columns of information that I want to link to a new sheet that people will work from. The information in these columns will be updated in the original sheet so I would like the cells to be linked instead of copied. In the original sheet, the information repeats so I only want the references…
-
INDEX Collect Based on Text String & Check Box
I keep going back and forth between Unparseable and Incorrect Argument trying the different ways I'm seeing these formulas done in another threads. I can't show the exact sheets. But, essentially, I have a client progress report that we want to show the 'most recent date contacted' and a sheet that we log all client…
-
CountIfs Formula
I would like the below formula to look at the Associate column (external sheet) and find Ashley. If it is Ashely then I want it to count if there is an issue logged in a four column range (same external sheet). It is comparing the issue in the range to the cell in my primary sheet. =COUNTIFS({Associate}, "Ashley", {Issue…
-
Trying to sum the value of multiselect selections
Hi Smartsheet Community, I have a project built out where as a team finishes a project they can submit a form for that project which will populate a dashboard of graphs to give leadership progress report. They want to be able to select more than one project completed at once so that they can input less forms, I'm right…
-
IF AND OR formula
I have been trying for way too long to get this formula working correctly - time to ask the pros. I would like the "At Risk" column to flag if "Due Date" has passed and if "Status" is anything other than "Completed" or "% Compete" is anything other than "100%" I've tried many different ways to get this to work without…
-
Pause Time Tracked
I have a request to create a way to track a certain record's time since it's been opened, but the user would like the tracked time to not include when it's in a certain status. For example, if the record is in "Open" status for 2 hours, have 2 hours tracked. If the same record is changed to "Waiting on feedback", however…
-
#BLOCKED Error with COUNTIFS when Range columns are populated via equations
Hi, I am trying to calculate the amount of "Used Inventory" by counting the number of times "Block Date" appears between "DATE 1" and "DATE 9" but am getting the #BLOCKED error. Columns "DATE 1" through "DATE 9" are populated by equations based on "CheckIn Date" and "CheckOut Date." Below, you can see the columns in use…
-
Clean up formula building experience
I would LOVE to see a significant enhancement to the experience of building formulas. Formulas are the single most common area of confusion, and the first "step" of any builder toward enabling automation and leveraging Smartsheet. Therefore, the formula builder could use some help to take it from "just as bad as excel, all…
-
Not able to generate Stacked bar Chart using REPORT
I am trying to bring - Stacked bar Chart for the monthly county of the competency. I have generated the data via Smartsheet Report in tis format. However, when I am generating the output report. The report is not rendering as expected. I believe, I can manually build a table with competency values and month and can…