Formulas
Discussion List
- I'm trying to use COUNTIFS - I have a column with multiple items and only want Client Success to be counted; the item also has to be In Progress; the below schema is not working: =COUNTIFS({Small}, HA…
- We regularly need to repeat one value (like 'industry') to appear on each row of our sheets so that when we pull data together we can slice and dice more easily. These are often hidden columns so they…
- When we set up a sheet we did not add an 'industry' column. I can link to a metadata sheet to get that information and link it to a single cell on my sheet . . . however, I need to have that value app…
- Is there a way to remove weekend and public holidays from Gantt chart? I'm planning a project with long durations per milestone, I would like to see only working days in the columns; alternately, can …
- I have "Column B" that pulls in a date from another sheet. And I have "Column A" that changes to Complete when that date populates into Column B. In addition, I have a criteria for which it should say…
- Hello, I am trying to count the number of weeks between two dates. I have applied this formula =WEEKNUMBER([SD End]@row - WEEKNUMBER([SD Start]@row)) It doesn't seem to be calculating correctly. For e…
- If I want to compare column 2 of Sheet D to column 2 in Sheet F, and return the value from column 1 in Sheet F to column 1 in Sheet D if 2D and 2F are equal, and not return anything if they are not eq…
- Hello everyone, I am looking to have an information sheet that is looking for several criteria with "and" and "or". For example, I want the formula to count if the other sheet has "Priority 1" and "Jo…
- I have a first sheet that was filled out by people using a smartsheet form to populate a sheet for a certification program. A second program is only open to the people who were already certified in th…
- I am trying to have a formula look at a "Parent" row Status IF it is blank than to then look at the child row associated and if the Status is Red, Green or Blue, place status within Parent Status ONLY…