-
Cell Reference if two cells contain specific info
I am trying to create some automation for invoicing and am running into an issue finding the right formula for cross sheet referencing. I have a product sheet with pricing and then have individual client order sheets. I want to return the price from the product sheet based on criteria in a "Product to Order" and "Container…
-
Date Formatted Column and Index Match to an Exact Date
I have a column that others fill in with a date, date column type is the easiest to prevent having to do a lot of clean up as rows are edited over time and dates may push to another month. I can also restrict the column to a date. If I am trying to use the index match formula below on a date column type it returns "blank"…
-
identifying last month to sum up separate column
Hi, I have another query: My worksheet includes a date column (mm/dd/yy) and I also have several other columns which include a 1 or 0 if certain criteria are met. What I need to be able to do is to identify if the month = LAST MONTH and if it does, to sum up, the values in each of the other columns separately. See the…
-
Smartsheet - Embedded Canvas
Is there any development progressing for an embedded canvas for each smartsheet line item. It's terrific that users can connect email traffic to a particular line through Outlook add-in Its terrific, attachments can be imported for each line item, either manually or through email What's not terrific is the connectivity to…
-
Show count of work orders not marked as resolved *and* assigned to a specific resource
Hi all, apologies for my lack of understanding here. I'm having a hard time wrapping my head around formulas enough to create something to accomplish this task. In a "Work Orders" sheet, there are two specific columns that I'm trying to pull from - "Status" and "Assigned to". On another sheet called "Primary roll-up", I…
-
Constant Error Code 18
Is anyone working on a patch for this error I receive while trying to save. I see this multiple time a day... formName: ajax formAction: fa_gridSave serverStatus: false serverStatusText: CriticalException errorCode: 18
-
Parsing Text into Child Rows
Good morning. I am running the Jira Integration, and I would like to create a view or report that lists linked issues (in the 3rd column from the screenshot) as child rows. The text will always be in the format ("includes OR-X") but I have several problems parsing the text. The key number (ex: 2437) could have up to 6…
-
Keeping rows updated once they are copied to another sheet.
Hello, I would like the rows I have copied into another sheet to be updated in real time or with a trigger or rule, without having to build an index/match cross sheet reference. Here's a scenario for the context. As Project Manager: I like to track multiple accounts in my sheets with multiple locations (every…
-
How do I move decimal one place to the left?
Formula for calculating minutes in military time but the decimal in the Minutes column is in the wrong place. How do I edit the formula below to move the decimal one place to the left? =(VALUE(LEFT([Clock Out (Military)]@row, IF(LEN([Clock Out (Military)]@row) = 3, 1, 2)) + (VALUE(RIGHT([Clock Out (Military)]@row, 2)) /…
-
How do I count the number of checkboxes within a column range?
I am trying to count the number of checkboxes in a column range and am getting errors. I would like to get a result that provides a summary of a specific range within the Priority 1 column. I have looked at some of the other posts related to this similar topic without success. Any help or guidance would be greatly…
