-
Count only outstanding items
I have a Request Management sheet with a Form that we used to track tasks. They template came with a Metric sheet that is very useful. One of the metrics on this Metrics sheets counts items by assigned person. I want to update that to count only items that are not Closed status. Current formula is: =COUNTIF({Requestโฆ
-
25,000 cross-sheet references limit
I use a lot of cross references in my sheets. In one sheet, myย blue arrow references have got the error code #CALCULATING on them which I know is because I must have gone over the 25,000 limit. I've archived about half the rows though and I'm still getting the same error. What am I getting wrong...? :(
-
Is it possible to add a new line in a Formula?
I found this discussion from 3 years ago: https://community.smartsheet.com/discussion/adding-carriage-returnline-feed-calculated-text It got a response from the community manager, so I would like to assume 3 years later it wasย implemented at some point Is there a way I can do this?
-
Auto generating mmm-yy cell
Hello, We have set up a cashflow sheet that gets graphed within a Project Dashboard. The example attached suggests that the Project commences in January 2019. Ideally, a user could enter the commencement month mmm-yy in Column 4 (Green Cell) and the adjacent cells automatically increase incrementally by one month acrossโฆ
-
Email Comparison Formula Needed
Hello Community, I am looking for some help with anย email IF Statement and a formula to more information, when a match is detected. I have a couple sets of 3 columns each: Email, First, Last and I need to compare Email with other setsย of Emails. NOTE: The 2nd or 3rd or 4th set of Email, First, Last will not have First andโฆ
-
Increased Cell references
Anyone know when (or if) Smartsheet plans to increase the number of cross-sheet cell references? I am getting this message now in my sheet, and its frustrating because I feel I have only started to truly make my sheet smart and truly useful. Does anyone have any "best practices" to share? I am currently referencing 5 or 6โฆ
-
IF AND OR
Hello all, I'm looking to use a Created By column to auto-fill my Primary column with a specific user's first and last name. I was planning on listing each user's email and full name with some variation of a IF/AND/OR or IFERROR statement, unless there's a more efficientย alternative. Here is my current and one of manyโฆ
-
How do I get a word count on a range of cells?
How do I get a word count on a range of cells? (Note: In the examples below, the text I need a word count on is in a columnย called "English" and the text I want to count is in rows 12 to 103.) I can get a word count on 1 cell using this formula: =LEN(English12) - LEN(SUBSTITUTE(English12, " ", "")) + 1 I tried replacingโฆ
-
Updating a current formula for a report in a widget to include dates
I have an issue where the current formula feeds into the report correctly and displays on the dashboard widget however, I have now been asked to change the formula to be date specific. I need to have this display by our fiscal year (July 1, 2018-June 30, 2019). Pro-desk gave me the formula to copy and paste but theโฆ
-
Search, If & Input
I've been having some difficulty trying to solve this one: * I have a master sheet where forms are inputted * For each row there are two columns I need to set up in an IF for, and one where I need a value inputted from another sheet * I imagine it like this: IF column 1@row = {other sheet} โฆThis reference should search anโฆ