-
Need Help with #INVALID DATA TYPE Error for COUNTIFS Formula with Multiple Cross-sheet References
Hello, I have this formula: =COUNTIFS({Certifications Range 2}, CONTAINS("CyberArk", @cell), AND({Certifications Range 1}, CONTAINS("Expiring", @cell), CONTAINS("Current", @cell))) I keep getting #INVALID DATA TYPE Range 2 and Range 1 are both referencing Dropdown list columns from another sheet. I know that the problem is…
-
Help with formula
I am working to port a process that is managed in Excel into Smartsheet. I want to created a formula that will check two cells in the row, if they both show filled, I want to check the checkbox. If either or both are any other status, I want the checkbox to remain unchecked. I want to convert this to a column formula. When…
-
#divide by zero error
I'm trying to create a column formula, but i get divide by zero error in the parent cell. I want the parent cell to be blank, but the formula will populate an answer in the children row. Is that possible? Formula is =AVG([Sep 2022]@row:[Dec 2022]@row)
-
Months between two dates
Hey everyone! I am hoping you can help me. I am trying to calculate the number of months between a date and today. For example, if the date is 01/01/22 and today is 09/20/22 I need a formula to show 8 months. The problem I am having is some of the beginning dates are in another year. Based on the formula I currently am…
-
Question about SUMIFS with CHILDREN with multiple criteria
The sheet summary formula "TEST" which is looking for the number of recorded docs Alex did for Friday. What I have right now is =SUMIFS(CHILDREN(Recorded:Recorded), CHILDREN(Name:Name), "Alex", CHILDREN(Day:Day), TODAY(-3)). It works if I remove either the day criteria or the name criteria but returns zero as it is above.…
-
Adding email list for Automations
Hi All, I have a Drawings Sheet that I use to update contractors with up to date drawings, I send them a simple published URL but do not share the sheet with them. (See below) I use another Project Sheet to run the project and keep a status of the jobs. In this lists all the contractors with a Purchase Order for the works…
-
Formula to combine Name and email to create a contact row
Hello, I have a very long smartsheet list of names and emails in seperate columns. I want to join them to create a new column that turns them into a contact without having to fill out the contact card for each person. I tried =Join({name}+" "+{email}) and it did join them, but did not turn into a contact. Help please!
-
Stumped on an IF formula
I have data in the following fields: Target Sales: Last Week's Sales: I currently have a formula that tells me if Last Week's Sales are less than Target Sales, then return "Yes" or "No" I need to update the formula to tell me if Last Week's Sales are less than Target Sales, are Last Week's Sales below more than 5% of the…
-
Filter and Calculation
Can we keep specific rows visible when applying filters? Can parent rows visible when using filter? Can we apply multiple filters? I've seen the articles discussing about it but not sure if it works now. I'd like to keep the rows for calculation (Functional Summary to Column15) visible and calculate the numbers when I use…
-
How to source a Drop Down list from a column in a Report?
I have a "PO Request" sheet where I want a drop down list of Vendors to be pulled in from an ever refreshing report of Approved Vendors. It seems incredible that this drop down has to be updated manually. Is this really true or is there a workaround?
