-
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…
-
How can I restore formulas and cell links in a sheet?
I have sheet that relies heavily on formulas and cell links to stay updated in real time. Recently the sheet was toggled with and no longer contains any of the cell links or formulas (only hard coded numbers). I do not know what every cell was linked to or its' formula. I tried to request a snapshot using the activity log…