-
Multiple if statements with And and Ors
I have multiple Ifs and I seem to have tied myself in a knot. =IF(NOT(ISDATE([Earliest Day 180]@row )), "Red"), IF(AND([Send HIE]@row = "Green", ePrescribe@row = "Green", [Receive & Reconcile]@row = "Green", [Provide Patient Access]@row = "Green"), OR(PHCDE@row <> "Green", [Query PDMP]@row <> "Green"), "Blue"),…
-
Formula to Change Symbol Color Based on % Complete
Hi all, I am trying to have the symbol color change based on the % Complete on a task. I have gotten it to work for 3 colors (Red/Yellow/Green) in another sheet, but now I am trying to do the same with 4 colors, including Blue. I am looking to have symbol turn Green when % Complete is at 100%, Yellow when % Complete is…
-
Pull Attachments from One Sheet to Another
I have sheets that pulls data from the sheets, then fills in a document and attaches it to a row. Is there a way to pull those attachments to another sheet so that all of my needed documents are in one place?
-
Formula for converting text/numbers - not working
I am trying to convert a total from "total time" column into something that shows "time" (so to speak). In this example the "total time" is 135 (minutes). So in Total Time (hh:mm) I need it to read , at the very least, 2.15 (doesn't have to be in hh:mm format). When I run my own formula or auto generate a formula it only…
-
Formula for Auto Reference Number
HI cpould it be possible to indicate time hour and minute in a formulated column i have sample formula in here but its still unparsable i able to create and test with some helper columns but still didnt work =IF([Case Type]@row = "Internal Service Issue", "ISI", IF([Case Type]@row = "External Service Issue", "ESI",…
-
How Can I Sum the Price of Multiple (join-collected) Items
I have two columns; one consisting of a list, using Join/Collect, of items, and one consisting of a formula to look up and sum the prices of the Join/Collected items. When the list (column 1) of items consists of only one item, the formula (column 2) works fine. When there are multiple items in Column 1, the formula does…
-
Referencing a specific level in a hierarchical setup
Hello, I am trying to do a count of statuses on a sheet but I need it at the second child level. In many cases there are children below this level also that I want excluded, and I also do not want to include anything from the parent levels above either. I do have a helper column that assigns a number code to each row with…
-
Dates in Timeline View are not the same as Grid/Gant View
Does anyone else have the issue where the dates in the Timeview line (mainly Milestones) are a day ahead of what they are in Gant/Grid View. It seems to be correct for some milestones but not others- I can only assume it's to do with predecessors with/without lag. As you can see on my screenshots, the ones highlighted…
-
Using #IFERROR to display #NO MATCH as a usable automation
I am wanting to use a helper column to display a value, lets say "Not Found", based on if the column "Attending? (from RSVP tracker)" is #NO MATCH. How do I use the #IFERROR command to do this? I can't seem to get my formula correct. I want to do this to be able to use and automation based on people not having a response…
-
Formula to separate first and last name from Contact List
Hi everyone! I'm trying to separate Last Name and First Name from a Contact Column. I'm CLOSE, but it's not QUITE working. I tried to take a formula I saw on another thread, but because I don't actually have an understanding of what the formula is actually doing, I'm unable to trouble shoot why it's wrong. It seems to be…