-
Count IFS and NOT(IsBlank
Good morning! I am attempting to use a sheet to count instances on another sheet and keep getting an Incorrect Argument error on the rows that should be counted. I am counting the number of jobs with a particular type where one column is blank and another is not blank. So count by Job Type, if Engineering Completion Date…
-
Workflow not working
Hello! I have set up a workflow similar to many we are already using, where when an actual finish of a project step is filled in, and at a certain stage, certain team members will get notified. The idea is when a row is changed to have a date in the actual finish section, with the condition of the stage being one of the…
-
UPDATE REQUEST Automation
Hello, Can you help me? How to turn off "Go to the sheet" in Update Request Automation email. Second question - Do I have the correct automation? I can't see my comment on the email I send? Third, can we highlight a row with an unread comment. Thanks.
-
Count Multiple items within a single cell - Countif ?
Hi morning everyone, Just recently started using Smartsheet platform for a project. Not sure I am doing this correctly or if there is an alternative solution. I am trying to count the number of rows which contains the provinces populated by a dropdown list (which has multiple input criteria ( AB, BC, MB, NB, ON, etc,) I…
-
Using Countifs with multiple references to other sheets
Been playing with this for a while but can not seem to get this right. Any help would be appreciated =COUNTIFS({Editing List-3-2018 Range 2}, >=(DATE(2018, 7, 1), {Editing List-3-2018 Range 5}, ="Name"), Date:Date, <=(DATE(2018,6,30), [Assigned to: Editor]:[Assigned to: Editor],="Name")
-
Calculating Time Duration with In/Out
Hello, I have reviewed several posts on calculating time worked from in/out time entries. I tried to use one of the formulas previously presented (see screenshot), but I keep getting an Invalid Operation error. If it helps, I am trying to calculate time worked using the 12 hour format.
-
Trying to use SUMIF to Sum one column but only of the items in another column
I am trying to get the SUM of SaaS Value if the value in the Backlog Status column is Active Backlog. Tried this and I am getting unparseable SUMIF([Backlog Status]:[Backlog Status],”Inactive Backlog”, [SaaS Value]:[SaaS Value])
-
TODAY function NOT working.
Hi All, Someone help me with this. I have 4 columns, TODAY, THIS WEEK, LAST WEEK and THIS MONTH… I am trying to count all the rows in a certain sheet that are THIS WEEK and marked "Ordered". =COUNTIFS({INTAKE SHEET 1 DATE}, TODAY(7), {INTAKE SHEET 1 STATUS}, HAS(@cell, "Ordered")) My issue - this formula (when changing the…
-
What am I doing wrong: =WORKDAY(TODAY(), [Number of Work days in funnel]@row, {Holidays})
I want to update a formula I have in the Estimated Funnel Fill Date column and I'm getting an INVALID DATA TYPE error. I can not figure out why this formula is not working. Can someone double check me? Here is the formula I want to use: =WORKDAY(TODAY(), [Number of Work days in funnel]@row, {Holidays}) The column this…
-
Use AverageIf to do turnaround time?
Hi, and thanks in advance for reading/helping. We're wanting to display up-to-the-minute turnaround times year-to-date for responses to entries. Some of the rows go back into 2022 and should not be shown as part of our metric. I am trying to use a sheet summary field to show the current average of response. I have the…
