-
Alert Someone on every day a Task is marked as happening
Hello, Can I create an Alert (Alert Someone) that would send a notification to an email for each day when a task is listed as happening in relation to the Start and Finish dates, inputted in the system? The logic cannot be static, and should be based on when a task Starts and when it is listed as Finished. Dates can vary.…
-
Parent/Child Formula
I need to create a formula where the parent row determines what it displays in its cell based on the following criteria from the children: If any child cell below it is blank, skip it If there is a name in any child cell, add it to the parent cell If it is a duplicate name in any child cell, skip and do not add to the…
-
Count Multiple Criteria
I'm trying to count a number of different items with multiple criteria. This is how I currently have it : =SUM(COUNTIF(Department:Department, "03 AACA Finance") + (COUNTIF(Department:Department, "03 AANJ Finance e"))) Is there an easier way since SS doesn't do arrays or do I need to keep adding the COUNTIF to the formula…
-
Forms - SmartSheet Form not the same as Form received by Action Parties to enter data
I have a Smartsheet that tracks Action Items. I created a Form that shows Action Parties data from Smartsheet and requires them to enter responses. The Form sent to Action Parties that appears in Emails and can be opened from the Email to enter responses does not contain the same cells as the Form in SmartSheet. Why? See…
-
Ability to create a form that will reference rows instead of columns
I have an existing extensive sheet that is built upon rows, i can only seem to create forms based on column headers, is there a way to do this for rows?
-
Formula to check box if cell contains Date OR Text
I have a nested formula that currently involves one check box be checked and three date columns to contain dates in order to check-mark as 'Complete.' However, I discovered one of the date columns involved may contain text from time to time (as a date is not always applicable to this particular field). How can I revise my…
-
Contact Lists and Formulas
Hello! I am new to spreadsheet formulas so apologies for missing what could potentially be very simple. I am trying to write a formula that will auto select the right contact if a certain number is inputted into another column hence auto-assigning a job. The formula works for inputing the right name, but only as text. Is…
-
COUNTIFS Formula "NOT" error
I want to calculate something for a dashboard. My formula references our team's tracker sheet. I am looking to use COUNTIFS for Tasks that are a specific Request Type, not a grand parent row, and not in our Archive section. The first part of my formula works, my Archive NOT rule is what gives me an error. I've included a…
-
Extract a value if today is between start and end date
Hi all, I've been trying to wrap my head around this and I have trouble trying to self serve to find an answer (or it's just user error on my end haha) I have a schedule with 3 main columns - the name, the start date and the end date. What I was hoping to do was extract who is currently scheduled if today was equal greater…
-
Can OR function be used with cross-sheet references?
I'm trying to use OR with SUMIFS in a cross-sheet calculation but it doesn't work. As an example the formula below yields a INVALID OPERATION error. =SUMIFS({TotalCost}, {Cost Center}, [Cost Center]@row, OR({Reason} = "Other", {Reason} = "Training"), {Region}, "Domestic", {Approved}, 1, {Year}, "2020") Thanks, TY