-
Auto-filling formulas in Sheet w/ Salesforce Connector
Hi All, I have a sheet that is connected to Salesforce opportunities using the Smartsheet-Salesforce connector. I'm trying to find a way to get my formulas to auto-fill in columns that exist in Smartsheet, but not in Salesforceย when a new opportunity is added to Salesforce and subsequently populates the sheet inโฆ
-
CountIFs with FIND
Below formula is showing incorrect argument set. =COUNTIFS(Name3:Name356, "", [Position Title]3:[Position Title]356, "Billing Specialist", [Req Status]3:[Req Status]356, "Open", [Dept Name & Cost Center]3:[Dept Name & Cost Center]355, FIND("10", @cell) > 0) Tying to countย rows that is blank in the Name column, withโฆ
-
Reporting progress between date ranges
Dear Community, I have searched the community for some solutions for what I am trying to achieveโฆbut canโt quite get there. I am working on some metrics around planned vs actual progress that I will plot on a chart. I have created a โmetricsโ sheet to count the tasks planned to be complete at the lowest outline level fromโฆ
-
% Complete for a row based on 6 columns of check boxes
Hello - I have a task list that has 6 columns - each column has a check box. I am trying to determine a formula to calculate the % complete based on the populated check boxes. Ex: 6 Columns - if 3 columns were checked the % complete would be 50%, if 2 columns were checked then the % would be 33%, etc. can anyone help me?โฆ
-
Vlookup from Excel to Smartsheet
My apologies if this hasย already been covered, but Iย didn't see anything specific to this subject when searching. I have a Excel sheet that has 45,000 + rows. The data in the rows are filled by 2 columns - United States Zip Code's and city's linked to those zip codes. This Excel sheet is used as a vlookup for multipleโฆ
-
Formula with multiple IF criteria
Hi all - Trying to create a formula that raises a flag any time a milestone is NOT marked complete AND the due date has past. Below is what I have tried and I am receiving an "Unparseable" error. =IF(Stage2<>"Complete" AND [Due Date]<= TODAY, 1) I am not sure that I am combining the two statesments correctly. Can anyoneโฆ
-
formula for dates
i have a question for a data sheet with completion dates i want to create a formula to count the lines marked completed with a date.. im using count if but is not working i was able to count the entries whenย no date availableย bu using ,"") at the end of the count if after my selection if any one can help me out with theโฆ
-
Formulas in Reports/Reference reports for Dashboard
I read in the community (the posts were a few years ago) that you cannot enter formulas into reports or that you cannot reference reports for a dashboard. Is this still the case? I having living data that really needs to be manipulated to get it prepared for a widget. I'm new to smartsheet and it seems like reports are theโฆ
-
Identify duplicate dates and exclude blank cells
I am working with a SmartSheet that is used by multiple people to schedule meetings. I am trying to check for duplicate meeting dates within two columns "Proposed Date" and "Proposed End (if multiple days are needed)". Dates are entered in rows 7-28. I have added a checkbox column titled "Duplicate Date" to be checked if aโฆ
-
VLOOKUP not allowing me to return value from beyond Column #20
Hello - I'm using VLOOKUP to return values from two separate data sets based on a unique identifier for my projects. For one of the VLOOKUPs, the column_num (column that I want to return the value from) is column 27. Why is it that VLOOKUP will return any value from columns 20 and below only?