-
How to get an approval after a decline in the automated approval request workflow?
Hi All, I have created an automated workflow based on a form submission that asks for the Approval of at least 3 individuals/roles. If an Approver declines, it will send and update request to the originator (Project Manager) and ask them to update information in the form. Once the Project Manager has updated the form, the…
-
How does COLLECT() with String Criterion Work?
I have a simple formula (I thought) that seems to broken. It seems to be centered around the existence of a String in the Criterion Parameter of COLLECT(). Formula: =IF(MIN(COLLECT(Date:Date, [Work Type]:[Work Type], "Mandatory"))=Date1, Hours1-6, Hours1) Result: #UNPARSEABLE Is it not possible to have a string Criterion…
-
AUTOMATICALLY MOVE A ROW WITHIN THE SHEET WHEN A CONDITION IS MET?
HI, I need to automatically move the rows that have reached a date within the same sheet into the next calendar year. When Agreements expire they have to be reviewed for the following year, I'd like to do this automatically. Is it possible to maintain the information within the same sheet? Thanks
-
Formula to change status based on current week/due date
Hello. I am attempting to have a status change to 'This Week' if a due date column falls within the current WORK WEEK. I am having a few challenges - 1) the formula is changing what is due 'this week' depending on the current date, NOT the standard Mon-Sun week, 2) I want anything with a blank 'Due' date column to default…
-
Taking photo on Dynamic view
I can easily take photo to attach on sheet but while using dynamic view, I don't see any options to take photo. Am I missing something ? Can I take photo on dynamic view by using my mobile device? Thanks in advance.
-
How to display a date from the sheet
Hi everyone, Does anyone have experience in making a date display in a date format within the Sheet Summary. I have tried to use ISDATE, DATE, and DATEONLY to no avail. I am creating the dashboard for this sheet. I want to display the Kick Off Call Date but I cannot get the date to display These are my results I want the…
-
Calculate progress towards a goal
I'm looking at two things - one to highlight when a goal is not on target to complete by a date. The second is note a specific amount in a cell on a certain date. To clarify on the first - I need a formula that will tell me if the number in the Target AUA cell is not going to be meet by the date next to the 90 days cell…
-
Nested COUNTIFS
I'm trying to count the matching items in two cells to a reference in another sheet. Individually they work with COUNTIF and produce the associated result but then I want to test both it comes back with "0". =COUNTIF({DNAC Adoption Range 1}, Partner106) = counts the correct partner name =COUNTIF({DNAC Adoption Range 1},…
-
What's wrong with this formula?
It returns only Complete or Not Started. =IF([% Complete]@row = "1", "Complete", IF([% Complete]@row = "75", "End in Sight", IF([% Complete]@row = "50", "Work in Progress", IF([% Complete]@row = "25", "Just Started", "Not Started"))))
-
Duplicate Check Formula
Hello There, I have created a column for duplicate check, It will flag the as red if both conditions are true Condition 1 : CPR ID Duplicate Condition 2 : Amount Duplicate Formula which is giving me error: =IF(AND(COUNTIF([CPR ID#]:[CPR ID#], [CPR ID#]1) > 1, IF(COUNTIF(Amount:Amount, Amount1) > 1, 1))) I think i am not…