-
Cross-sheet formula with checkbox
Hello all, I am trying to create a cross-sheet summary metrics sheet that counts data based on Status and whether a box is checked. If the "Project?" column check box is checked AND the Status is (for example) In Progress, I'd like this formula to count the number of instances. No matter what I try for the checkbox (true,…
-
Populate Contact List Column with Value from Another Table With Date Condition
I want to populate cells in a Contact List column that is used in workflow automations based on a formula that pulls the contact(s) from another sheet. Sheet fields: Resource(s) (type Contact List that allows multiple contacts per cell) Start Date (type Date) End Date (type Date) Position (drop down - single select) My…
-
IF, THEN formula that references a checkbox field and a date field
I'm trying to write an IF, THEN formula that references a checkbox field and a date field, but I keep getting errors. Here's the logic: If the 'EMDS' column is checked, then calculate the 'Date Needed' column minus five days. If seems simple, but it may actually be too complicated for the system since it essentially…
-
How to make % frequency chart in dashboard (reasons for QC failure)
Hi, I am trying to make a chart in my dashboard that displays the reasons for QC failure as a percentage of overall frequency. The input is from a sheet with a column as shown below. You can select the mode of failure from a dropdown menu, and can select multiple items if there are multiple modes of failure. "In Dashboard"…
-
Using IF/AND with INDEX/MATCH
Hello - I have multiple sheets set up to feed into 1 result set and am trying to find a way to pull information from the result set into a table, if the criteria is met. Here is what I have, however, I keep getting #INVALID OPERATION. =IF({BCOA Range 11} = "YES", AND({BCOA Range 10} = "LCB", INDEX({BCOA Range 12},…
-
Populate cells based on the different select of a multiselect column
Hello, I'm not sure how to handle this one and your help will be much appreciated. I have one MultiSelect column with a number of Main Countries (coming via a link from another sheet). For each country present in the Multiselect, I'd like to populate one cell with the country name. I just have no idea how to do this. Can…
-
Two date columns - need to take the earlier date of the two and add 10 years
Hello! I am hoping for some assistance with nailing down this formula so that it displays 10-years on top of the earlier date from two columns. I found a prior community post with the below formula, but I just can't seem to get it to work the way I want it to. =IF(AND(ISDATE([Last AF]@row), ISDATE([Last BIR]@row)),…
-
Can you use the COUNTIF function with another sum formula?
Hi I was wondering if someone might be able to help me please. I have a sheet that lists PPE items, i.e. Item, size, quantity taken etc. I have used COUNTIF to identity what has been taken using the following: =COUNTIFS(Item:Item, "hi-viz polo shirt", Quantity:Quantity, >0) Which returns the number of rows that have the…
-
Embed Salesforce Dashboard in Smartsheet
Anyone know why my Salesforce Dashboard won't embed into Smartsheet? We have the Enterprise license for Smartsheet but when I try to put in the Salesforce Dashboard link into a Web Content widget, it still tells me that it's invalid. Thanks!
-
Counting Children Tasks with specific criteria
Example: In a large sheet - I need to look for specific "tasks" that fall under a parent row. Parent Row has Brand, Month, Quarter, etc. Child Rows have specific tasks. So I need to count the number of times im asking for "Task X" if Parent Row has "Brand Y" and is released in "Q4" Another way to explain this - If the…