-
I need an update request to include and item name and quantity, but only edit the qty.
I need to set up an weekly update request for supplies to update quantities. If I include both the "Item Name" and "Stock Quantity" columns in the request, both fields become editable. I need the item name to remain so the person doing the update knows which of the 98 items on the list they are updating. I tried locking…
-
Recording words from Column B to Column A
Hi, I'm writing to write a formula that will record certain words that appear in column B into column A. Column B is a dropdown menu with multiple options available. I only want to record the words RED, BLUE, PURPLE, if they appear in column B and if none are present, I want the cell to remain blank. I'm struggling to know…
-
Extract 4th email address from multi select cell with CHAR(10) as delimeter
I have a multi select cell that contains 4 email address, separated by CHAR(10). I have been able to isolate the 1st, isolate the 2nd and isolate the 3rd in columns to the right. 1st email is extracted with this formula —> =IF(FIND(CHAR(10), [Names of Approvers needed]@row ) > 0, LEFT([Names of Approvers needed]@row ,…
-
Combining SUMIF( and AND( Formulas
I am attempting to sum a large amount of data into totals based on unit, month, general ledger title, so for example: get a total $ amount for Misc Income in the month of July for X Unit. I'm getting an #UNPARSEABLE error. Are there any clear errors here? I cannot figure it out. =SUMIF({CEAS Budget v Actuals Testing Range…
-
Publish Option Missing on Grid Sheet Despite Being System Admin with Publishing Enabled
I’m running into a publishing issue that I can’t resolve, and I’m hoping someone in the community has seen this before. I am trying to publish a standard grid sheet, but the “Publish” option and the globe icon do not appear anywhere when I open the sheet. Here’s what I’ve confirmed so far: • I am the System Admin • I am…
-
Need To Figure out a way or a Formula
How do I split the numbers into the same sheet when they are in a same cell like an array which has been brought to that cell using a formula. Eg: i have 182,183,184…. in one cell and I want to split them and create a row for each number on it's own. How do I do that?
-
Disable auto update of start dates for dependent tasks
Looks like there was a thread on this https://community.smartsheet.com/discussion/7262/forced-dates-when-dependency-is-enabled to disable auto-update of start dates when using the predecessor feature.. is this implemented?
-
Last working day of the current month
I need some help with the following formula: =WORKDAY(DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1) - 1, 0) The formula stopped working this morning, and is now showing #INVALID VALUE instead of the date (I'm expecting 12/31/2025). Can someone tell me what is wrong with the formula that it's not giving me a date?
-
Sum based on two columns, words and sum numbers
Hello, I am trying to figure out a formula that will SUMIFS my first range says "Perfect Match 111" and my second range has a number in it. Example if "Perfect Match 111" is in my first range 3 times then I want it to sum the number that is in my second range. So below I would want 6 to come back to my sheet. I have tried…
-
COUNTIF CONTAINS returns 0
Hello all, Running into issues with a new set of syntax I'm trying: =COUNTIF(CONTAINS("2026", {sheet being referenced column}), "True") Keep getting a return of 0, even though there are projects releasing in that referenced column. Thanks in advance!