-
Formula with Dates and Blank Fields
I have this formula that shows if a project is completed on time or if it is late. But there are occasions the the Proof Due Date will be blank. How would I modify this formula to say No Proof Date, if the field Proof Due Date is blank? =IF([Completion Date]@row > [Proof Due Date]@row, "Late", "On-time")
-
Automated Workflow -Advanced Options not giving all dropdown choices
I am trying to do a series of automations for approvals, and I have the advanced options of 'submit', 'approved', and 'declined, but I also want to have 'more information required'. I do not have this choice, although it is a dropdown in my reviewer column. I watched this you-tube, https://youtu.be/b39T07grJlY and my…
-
Hide Zeros
I have the following formula... =COUNTIF([Mar 31 @ 7:10]@row:[HOU 3 Sun]@row, ="1") When the result is zero, I want the cell to be blank. How do I do it?
-
Project Health Automation on % Complete and Start/Finish Dates
For some reason (Probably user error) I do not receive responses back when I reply to an already created item - so please let me know what I can do better next time. I have this formula very close thanks to all the wonderful advise you have provided still a nogo. Standard Project plan looking for Health - IF([%…
-
Using Contact List data in IF statement in Sheet Summary
I'm working on a system of sheets to track requisitions within our Talent Acquisition team. I've built out a helper sheet designed to help us track the average requisition priority ranking that each recruiter has. Since this is a helper sheet, its only purpose is to gather this metric, so I don't care what the sheet looks…
-
Nested IF / THEN / SUM Formulas - Based on Values in Drop Down List
Hello! I am working on a Commission log and tracking project. The commission amount is based on the amount billed which is contingent on the contract billing cycle rather than the total cost of the sale. So, I am trying to create a formula that will calculate the billing amount based on the bill cycles from a drop down…
-
Customer Survey and NPS Scoring
I have set up of customer survey that includes an NPS question. I am not too familiar with reporting and dashboards yet, so I am having a difficult time envisioning where I should do my NPS calculations ie. Intake sheet, separate sheet, report, etc. This is also my first "solution" build. Currently, I am putting the…
-
Countif and Multi line cell
Column 1: Status Column2: Count Column 1: test Column 2: =COUNTIF([BOP Status]@row, "test") Result = 1 Column 1: 2 lines. (1st line "test" , then Alt-enter, then "found in a test" Column 2: =COUNTIF([BOP Status]@row, "test") Result =0 Is there something about using Alt-Enter that causes this issue? is there a work-around?…
-
Counting Instances from Sheet 2 Based on Criteria
In Sheet 1, I want to report the number of instances of a string, based on two criterion : (1) BL or OL and (2) Development Term. SHEET 2 COURSE | TERM CODE | MODALITY | SOURCE TYPE | STUDENTS | COMBINED ENG 101 | 201910 | BL | M | 25 | ENG 101$201910@BL^M~24 ENG 101 | 201930 | BL | M | 18 | ENG 101$201930@BL^M~18 ENG 101…
-
Can a calendar view of a report reflect the formatting/formating of the underlying sheet or report
Hello everyone!! We use a sheet to schedule staff for events. We have about 30 to 50 of those folks. We use the update request for them to accept or not. We are in a fast-paced industry where things change often and rapidly. To help them continuously see where they stand, I have built a report for each person. I then have…