-
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…
-
Generate Ducuments with Multilines
Does anyone knows if its possible to create a document using more then just 1 line a time, meaning if i have 10 rows that i want to include into same document : example Creating a packing slip from multiple lines
-
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…
-
Averaging percentage from 3 columns in one row
I have 3 columns in one row and I'm trying to show the average of the percentage of work done from those three columns. I've attached a screen shot. In one example, 25% is done from one column and 0% is done from the other two columns. The sum/average shows 54% complete In the next example I actually made all 3 columns…
-
Calculating start and end dates of periods into dates into the next year
Hi, I have a 2 tracker sheets, they both have columns for 12 periods, P1, P2 etc., rather than the names of the months as they can start at any time and run for 12 months. First tracker sheet - The start date for the tracker can be, the first day of any month. Second tracker sheet - The start date can be any day of the…
-
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…
-
My conditional formatting is not showing consistently in my reports, what did I do wrong?
Hello, So I have several conditional formatting rules set up and after adding a few more that were needed for my team, some of the formatting is not showing on my team's reports for all the rows. Example: I have a format rule for a drop down list column where when the word Need is used, that cell should turn yellow. The…