-
Count if NOT BLANK
Hi. I am trying to write a formula with multiple criteria to for my metrics sheets; however, I'm not sure how to add this one count if not blank. This is my current formula: =IFERROR(COUNTIFS({OHCA Form - Agency}, $Agency@row, {OHCA Form - Review Complete}, "Medical Review Complete", {2020 OHCA Form - Etiology},β¦
-
COUNTIFS Error
I am attempting to build a COUNTIFS formula that references another sheetex: =COUNTIFS({Completed Strategy Updates (Goal Primary) Range 1}, 1, {Completed Strategy Updates (Goal Primary) Range 2}, "100%"). I am trying to get all data from "Goal 1" that is less than or equal to 25%, then another that is 26%-50%, etc. Theβ¦
-
Automatic indentation
Hi, I am using Data Shuttle to bring data from an external source into my SmartSheet. I want to automatically indent based on the Unique ID as shown in the below example. The Unique ID with the lowest suffix should be the parent row and subsequent ones should be children. Is this possible to achieve with a formula or someβ¦
-
Request an update - email format
hi there, I have created a workflow that will email the requester when status changes to complete. below is the view of the mail received by the requester. is there any way to clean this up so it looks more professional when the mail is received. it seems like spaces and lines get removed for the email body
-
how?
I am trying to add multiple columns with certain criteria, but I get a 0 and no the actual answer. The formula I am using is =COUNTIFS({1. Tech Sonic All Incident Summary Range 1}, {1. Tech Sonic All Incident Summary Range 2}, {1. Tech Sonic All Incident Summary Range 3}, {1. Tech Sonic All Incident Summary Range 4}, {1.β¦
-
Can a form be updated once it has been submitted for approval?
We are using a form to capture requests for purchase with approval automations. If the person submitting form submits with an inaccurate cost estimate, can they return to same submitted form and edit it for second approval? Also is there a way to put a timing formula i.e. like 24 hours or 48 hours on the approval to remindβ¦
-
Countif with Min and Max Date Range
So the excel formula I'm trying to replicate is below. Basically, I'm trying to count every cell that has a date between Jan. 1, 2021 and Jan. 31, 2021. The outcome should only be one number. =COUNTIFS(Sheet1!N:N,">=1/1/2021",Sheet1!N:N,"<=1/31/2021") But I've tried so many things. I can't figure out what try next. I'veβ¦
-
Form Pre-populated Fields
Hi - I am wondering if there is a way to auto populate a form with weekly recurring project status reporting fields to reduce repeat data entry for our reporters. i.e. project name/start date/end date/client. Can a form be automated for pre-population in specific fields say by selecting project name in a drop down? Thanksβ¦
-
Help w/Change Cell function
Hi team - I have a column (Entry type 1) that I want to change to Best Practice (drop down selection) when Best Practice Delivery Area 1 is not blank. I created this workflow but it will not change Entry type 1 to Best Practice, it just remains blank (see above). What am I missing?
-
how to formula contain in a cell
Hi, i am trying to formulate countif and contain in a formula but can't seem to do it right. i want to countif the cell in this column contains certain words because some columns would have two answers so the direct countif , value = xyz doesn't do the trick.