-
Add # days from a column to Invoice Date
I tried using AI which generated this formula. The error message I get is #INVALID COLUMN VALUE. Can an expert tell me how I can correct this please? The requirement is to take an invoice date column and add the value in a second column 'payment due in X days'. =[Invoice Date]@row + VALUE([Payment Due (in days)]@row )…
-
Merged: GRANDCHILDREN Function
This discussion has been merged.
-
Using report information in a new sheet
I am working on creating a streamlined way to obtain information from our 66 non-profit groups in order to request specific credentials based on what zone their group will be working in. I only need full name and email addresses from the group leads. All other information needed, I and operations managers would enter. I…
-
New Formula Error message #ERROR IN RANGE
Right now the Smartsheet formulas will pass through errors that exist in ranges referenced in formulas. This can result in error messages like "#INVALID DATA TYPE" in formulas where that is fundamentally impossible - making trouble shooting much more difficult. If, instead of opting for passing through any existing error…
-
WORKAROUND FOR AUTOMATION EMAIL TO RECEIVE SEPARATELY AND NOT BUNDLED IN ONE E
Hi anyone here have a work around or formula in my case i created a project where in Effectivity date reach it sends email notifications i also created a helper column for subject to have a unique fields and not bundled in one email but in this case if the same effectivity date different details it was placed in one email…
-
Looking to add differentiators? How can I do that without using RAND
I am looking for a solution that woul d create a unique identifier for my row. I am using a index match formula to pull through needed fields, however the items that I am matching often have the same names on the reference sheet. I cannot adjust the names, but I would like to build a column that is unique to each row.
-
Formula to determine number of plants still in inventory which were acquired more than 6 months ago
Good day, I have a native plant nursery, and I am looking to determine the number of plants that are still in the inventory and which were acquired 6 months ago or more. So, a rolling SUMIFS maybe? Wanting to do this in the sheet summary, but open to other solutions that I can display in the project's dashboard.
-
Add Columns through Global Update that Contains Formulas with Cross-References?
I am working on a large update to a project that has 130 toolkits generated through a blueprint. I have to add up to 20 new columns that all would be a column formula containing cross sheet references to another sheet within the toolkits. My question is, if I do this using a global update, would all of the sheets be cross…
-
Can a form be populated via URL from multi-line text?
I have two sheets, one is titled "Test Scenarios", it's a sheet that contains steps to complete a test scenario, the other is titled "Test Issues", it collects testing issues submitted via form URL. When a test scenario fails, the user selects "failed" from a multi select box which causes a form URL to display. The URL…
-
SUMIF with AND function
Hi - I'm trying to sum the "Bill Check" column if "Receipt" is unchecked and "Revenue Check" is 0 (will be displayed as 0.00). When using the below formula, i receive the #UNPARSABLE error but i can't resolve the issue. =SUMIF(AND([Receipt]2:[Receipt]762 = 0, [Revenue Check]2:[Revenue Check]762, "0.00"), [Bill…