-
Summing IF and After 7
Hello, So I don't even know if this is something I can get a formula to do, but I am trying to get a number to check a cell reference and start summing if the number is above 7. But here's the kicker, I don't want it to sum the entire amount. I want it to essentially sum the number, minus that 7, but only sum the numbers…
-
nesting If. Can't figure out why I get unparseable error
Here is my formula. It is in a project plan: =IF(TODAY() > [End date]1, [% Complete]1 < 100%, "At Risk", "On Time")
-
Deciding what rows go on my calendar view
I have done this before but can't get it to work this time. In fact, in my current sheet. However, I can't remember how! I have a checkbox column called SHOW IN CALENDAR. I want the check box to determine what shows in the calendar view. Did I create a separate filter with this before? I just want what I want to show in…
-
Time of day
As an event planner I need to assign start and end times i.e. 9:00 a.m. - 3:00 p.m. to meetings and tasks that need to be completed. I can obviously type in the times, but they do not sort correctly as anything starting with a "1" regardless of AM or PM will shoot to the top. I can put a "0" in front of any AM times, such…
-
Highlighting Individual Cells Based On Date
I am trying to figure out how to highlight a cell based on how the status of the "actual" column is in accordance with the "Baseline" column. Is there a formula or conditional formatting rule to implement that will automatically change the color of the cell to green or red to illustrate that it is ahead or behind schedule?
-
Delete License User request
A new user at my company inadvertently sent a license request. I can't find an option to delete it. Help?
-
Converting result from an Index & Match formula from date to text
Hello all, I am trying to work on a formula to make it easier for me to work on Global Updates in Control Center easier in the future. I currenly have a formula that coverts the data from Date to Text instead of just a simple link to the (lets say) the Start Date column; I had to do this because of the Global differences…
-
Project sheet - with multiple duration columns
Hello I need to add multiple columns that allows us to input the "on site date", - "Manufacturer Lead time" - "Drawing Approval" = Drawing start Date. Screenshot as below. Appreciate any help to solve this issue. Regards Daniel
-
Drag and drop from Google Photos
Is there a way (or an add in) to drag or attach photos directly from Google photos to the attachment window in a sheet? I know I can upload from a Google drive but that requires me to save my photos to my drive. The other option is to save them to my computer. It's cumbersome to do that.
-
Calendar App
Hi, I have been using the Calendar App for some time now, but noticed that team members whom have recently got the app have new features that I do not. They are able to custom color code things where my app settings still show just the example tiles and does not give any options to custom color code. Is there a way to…