-
Count Blank Formula
Hello, I was wondering if you can help me with my formula. How do I count my Battery CE Leads Range 4 when my cells are "blank" I need to count sum of Blanks each month. Thanks. =COUNTIFS({Battery CE Leads Range 3}, "Unqualified", {Battery CE Leads Range 4}, $[STATUS UNQUALIFIED]@row, {Battery CE Leads Range 2},…
-
Formula to move a cell from one sheet to another based on conditions
Hi all, I'm currently using Zapier to move data from a google drive to a data source Smartsheet. During the transfer, sometimes there are multiple rows with the same claim numbers on the data source sheet (that part isn't going to change unfortunately). I have a separate summary sheet that that pulls the information I need…
-
Intake Process: populating one row with 2 form submissions?
Hello I have a workflow mapped out and Im stuck as to how Smartsheet can handle it Part 1: this is where an internal user populates a form with a few fields: one of the fields is a 'Supplier Name' which contains an email address Part 2: this triggers a workflow where the Supplier - as above - receives a form Part 3: once…
-
Copy rows to another sheet using workflow
Hello I have a workflow which triggers when a column (calculation) changes to value to anything above 15. The workflow then is set to move these rows to another worksheet, using a condition whereby status = 'open' from another column. All looks good, but nothing happens on the destination sheet when I run it. What am I…
-
SUM Formula
This discussion was created from comments split from: Help with SUMIF function with data from another sheet.
-
Needing help with a formula for project health
hi, i am trying to figure out a formula, but can't seem to work it out. if a task is in progress, the project health column should change to green if a task is 15+ days from start date, the project health column should change to yellow if a task is within 15 days of the end date, the project health column should change to…
-
INDEX/MATCH when the MATCH is a multi-select drop down column.
Hello! I have set up an Index/Match for the Secondary ID to be matched to the Sites Under Consideration. This works for the rows where there is only 1 selection in the Sites Under Consideration column. It gives a #No Match error for the rows with multiple Sites selected. I would like it to work and list all the secondary…
-
Start date auto update?
Hi, everyone. I'm very new to using Smartsheet and am having some troubles regarding start/finish dates. I'm trying to find and use the correct formula/automation to change the start dates if the previous job task has run over its allocated time. For example, I use Smartsheet to schedule trades for job sites, if a tiler…
-
I am trying to replicate a formula, but it is changing all the formulas on the page
I am trying to create the formula in the "Activities" row, to the "Issues/Pain points" row with a different reference column. I also need to change the reference sheet, but I want to get this formula right in the first instance. Can anyone help?
-
Help needed for SUMIF, Date Range
Hello I am having trouble with the below formula to return date based on a date range and getting a return of #invalid operation. I checked this out in the community but not able to find a resolution. =SUMIFS({All PM PO Tracker-Assigned To}, "Project Manager", {All PM PO Tracker- Change Order-Submitted}, "Invoiced",…