-
Formula Tips are Obscuring the Actual Formula
Hello, Could anyone provide a trick to move the formula tip dialogue box? I am getting an Unparseable error message, but I cannot see the formula to check the syntax (see attached screen shot). Are other people facing this problem? Is it browser specific? I am working around this by copying and pasting parts of my formula…
-
AND not working beyond 2 logical expressions!
Hello I feel like I'm taking crazy pills!!! I have the following formula to change the value of a cell, to encourage the population of cells for a tracking sheet. =IF(AND(ISBLANK(Designer6), ISBLANK([Designer Start]6), ISBLANK([Designer Finish]6), ISBLANK(SME6), ISBLANK(CRE6)), "Pending...", "Click Save to notify!") It…
-
if checkbox
HI, If a checkbox is selected in column "SNAGS" can another column "DATE RECORDED" automatically populate the date in which the checkbox field was selected? Regards Stuart
-
Find next / subsequent date in list
Hi, I am stumped. I am trying to figure out how to figure out the second (and third) date for each unique entry in the Provider/Resource column. I am using this formula to find the first date: =IF(Date@row = MIN(COLLECT(Date:Date, [Provider/Resource]:[Provider/Resource], =[Provider/Resource]@row)), Date@row, 0)
-
Sumifs with Checkboxes
I have a worksheet that I am using for adding event entries in via a form. The entries will check the boxes of the events they want to enter. Each event is a different cost. I want to do a final column for each person entered that will add up each row based on the events given $ amount if the box is checked. Events: PWB…
-
Notification/Reminder for Past Due Task
I have reviewed the many questions asked previously by others regarding Notifications and Reminders as relating to dates and I am either not understanding them or they are different enough from my application that I don't feel the solution is applicable. I am simply attempting to send an e-mail to an individual whenever a…
-
Importing/Syncing Excel File
I have created some sheets that reference a master sheet. This master sheet was populated by importing an excel file. The data in that excel file is generated from a web page that exports to excel and is constantly updating. I'm seeking a solution to be able to update my master sheet. Importing doesn't work as it creates a…
-
Task Constraints
How to you apply constraints on tasks eg. Must finish by, start on etc.
-
Check cell range and compare against date today()
I have looked through and tried to apply several solutions and none seem to work with a range of cells. I have a date/time field column under and have entries in several different collapsible fields. I am in need of help creating a formula that will check all the cells in the range/in the collapsed range (are they children…
-
Formula help
How would i add the children rows, that has the below sum? Grandparent - SUM??? Parent - ="Total: " + COUNTIF(CHILDREN(), 1) Child - Tick box Hope this makes sense.