Formulas
Discussion List
- Is there a correct way to add contacts into a formula? I am trying to sum the number of attendees per VP (could be a couple VP's in this multi-select contact column) training request. Do I need to typ…
- Hi all, First question in the forum. I'm in need of help with an INDEX(MATCH( formula that I've been using but now need to make conditional on another column. Essentially, I only want the INDEX(MATCH(…
- I have a 600 row Smartsheet and need to provide hyperlinks for each row to an external Excel document. At the moment, a basic hyperlink will open Excel but place the cursor at the top of the sheet. Ca…
- Hi, I am trying to figure out how to write a formula to return a value from the SAME ROW, when criteria is met. I can't figure out what I am doing wrong with index/match/collect - I am hoping someone …
- Good afternoon, I'm trying to do the equivalent of '"AVERAGEIFS". I read about using the collect formula, but I'm having an error. The formula I'm using is: =ABS(AVG(COLLECT({Master Sheet - 1960 - Net…
- I have this spreadsheet, What i want to do is basically in hotel nights - I want to be able to do following. The initial date for Hotel nights - I want to set it lets say May 1 2024. then i want the n…
- Hey Folks, I'm trying to create a Chart Widget to show Metrics for how many lines are down due to specific inoperable Status type and thought I had this worked out but am struggling to generate that f…
- I want to count the number of parents in a column, I am able to count the number of children and descendants using, =COUNT(CHILDREN([Primary Column]:[Primary Column])) and =COUNT(DESCENDANTS([Primary …
- Sorry if the language is confusing, but here is my example: We are encouraging daily physical activity for our staff. Entry will happen on a Form connected to a sheet where data will be stored and mod…
- Hello Exports, I am building a report based on a source sheet. The report should extract the rows based on the criteria "This Week". Can you please take a look the pattern of screenshots and confirm i…
