-
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…
-
#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…
-
Merged: Clean up formula building experience
This discussion has been merged.
-
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…
-
Allow formulas in Assigned To when Resource Management is enabled
Currently, with dependencies enabled the Start, Finish, Duration fields do not accept formulas. Additionally with RM enabled (including the new Resource Heatmap), Assigned To can no longer be formula driven. Use case: when our Marketing team generates a copy of their campaign sheet, they have a number of pre-set tasks that…
-
What is wrong with this formula?
I am trying to summarize the quantities of each different sized container that is also checked as being shipped off-site to use in a dashboard pie chart. I tried the following formula, but I get '#unparseable'. What do I need to fix? Or coincidentally is there a better way, using reports, dashboards, however, to visualize…
-
Freezing Dates
I am looking to have a blank cell populate a date in a column using an if statement to check for specific values in another column. With excel I would normally use a circular reference to check if(and()) the cell was blank and that the values I want are in another column, and then populate a today(). With Smartsheet it…
