-
Nested IF Help
Hello, I have these columns: In a perfect world, when the status changes to RESOLVED, the date resolved would automatically populate. Since I can't do that without the use of something like Zapier, I'm trying to define a workaround using an additional column "Days to Resolve". Some issues have been resolved, but a…
-
Form Permissions?
I don't think this is possible, but I am asking anyway - if it's not possible I would like this added as an enhancement request... I'd like to see forms within sheets be able to be used by specific people only. The current options are basically anonymous (anyone with a link) or an authenticated user (could be anyone with a…
-
Report as a daily reminder.
Hi, I have strange problem. Becouse my coworkers would like to have a report sent daily in the morning. So they can see what tasks (from few sheets) they are assigned to. I already've made those reports and tried to "send as attachment" but it doesen't work (don't know why it isn't sending pdf's like I made it on a…
-
Merged: Alert/notification sender email address
This discussion has been merged.
-
Count Children formula
I have this formula that is working properly except I need to adjust it. Basically what this formula is doing is counting the children rows if a specific date column has nothing (is blank). However, what I need to also adjust for is to have my formula return a "zero (0)" if the units have expired (captured in a helper…
-
Countifs error
Hello, I am trying to count the number of occurrences when column1 = value1 AND in the rows that have a check box in column2. Can anyone see why this formula is #Unparseable? When tested individually, the formulas work but together I get an error. =COUNTIFS([column 1]:[column 1], "value 1”, [column 2]:[column 2], "1")…
-
Multi-Layer Formula for COUNTIFS and IF
Hello, I am trying to see the number of employees that called off for each shift for yesterday only. This is what I have so far. I want to see the number of employees that called off on "Shift A" and that call off is "Unscheduled" , but ONLY want to see any calls with the call-off date that was yesterday. Do I need an…
-
Logic formula for checkbox
I am trying to get a box checked if a completion date has been entered OR a status has been marked complete. Formula I have is =IF (Status3 = "Complete") OR NOT(ISBLANK([Real Completion Date]3)),1 What am I doing wrong here?
-
Countifs with special requirement
Hi, I need to use countifs to count the number of calls made to customers today. In my example, Touch 1 and Touch 2 are calls today, however I also need some filtering with user input. The criteria are as follow: Date equals to "Free Text Date" of 20/04/2020 (X1) Salesman equals to "Free Text Salesman" Peter (X2) Only…