-
Counting number of tasks per Assigned To contact as well as by project
I have 24 projects, the same team is working on any number of tasks in each of these projects. I want to see the following: 1) Task count per assigned to 2) Task count per assigned to and by project 3) status of each task that each team members has So far I have Created columns on each project sheet with column headers…
-
Counting rows that contain specific years
I'm trying to create a formula in my sheet summary that will count the number or projects that contain a specific year in a column that shows the start date for the project. I have a task list spreadsheet and it contains tasks that started in multiple years but I'd like to be able to show metrics on our dashboard for how…
-
Updating a cell value in a Smartsheet based on change with another Smartsheet
Hello, I have two smartsheets. And there is an automation defined between them. Whenever Status column changed to "Scheduled", it triggers workflow and related row/rows copied to another Smartsheet. In the target Smartsheet, there are also some manual entries. This works fine. I have another need. Now if Status column…
-
Formula to Capture Previous, Current, & Next Quarter
Hello, I have a spreadsheet with information populated from Jira. Unfortunately it does not contain information like start and finish date, but uses quarters instead. I am creating a dashboard with pulling reports for Previous, Current, & Next quarter, which I would like to automate. I've tried a few formulas, but haven't…
-
Last entry in a group
OK, so I have a report and it has several columns. One is serial number. I have all of the entries grouped by serial number. I now would like to view only the last entry for each serial number. Is there a way of doing this? I do have a column for date.
-
IF AND formula
Hi Experts, I'm using below function in column "Model count" which works fine, =IF([helper column]@row = MIN(COLLECT([helper column]:[helper column], [Model Number]:[Model Number], @cell = [Model Number]@row)), 1) but I would like to add another check upfront. If (Article dev type)@row is NOT "CO", than it should use the…
-
URL Query String to Populate a Form - Issues with " \ % characters
I'm playing around with the URL Query String to populate a form with data from one sheet to add it to another sheet (essentially, to copy rows, but only the columns I want). The problem I'm having is that at least 1 of the fields is a description field and can be quite long and have a gazillion special characters in it.…
-
Automate Split Text to Columns, after row creation from form.
I am creating a sheet for the purpose of inventory. On our items being inventoried they have a QR code that generated txt info. I want to split the txt into several separate columns. Example of what is generated: Model Number: AS3100 Size: L Lot # 20-4186 Serial # 27233412 Level: IIIA D.O.M. 06/2020 I want to auto-fill 6…
-
Help - Approval workflows with multiple approvers and conditions
I have an approval request that is currently set up like this: local leader approval is obtained. If these 3 conditions are met: a. if budget is greater than $5,000 or b. attendees = govt or c. carrier sponsorship = yes, then next level approval is required. Otherwise, requestor is notified of approval. Ditto with decline.…
-
Need assistance with IF Or and IF Not formulas
current formula has syntax errors : IF(OR(Region@row = "a", Region@row = "b", Region@row = "c", Region@row = "d", Region@row = "e"), "email1", IF(OR(Region@row = "F", Region@row = "g", Region@row = "h", Region@row = "SMA"), "email2"), If(NOT(Region@row="a", region@row="b", region@row="c"), [departmentdirectoremail]@row,…