-
x-sheet formula help
I am attempting to write a cross sheet formula on sheet (call it sheet a) that returns the value of a column on reference sheet b, based on finding a string of text found in anther column on sheet b that matches a Project ID on sheet a. Here was attempt 1 that didn't work =INDEX(PERFORMANCE AMOUNT), MATCH([PROJECT ID]@row,…
-
Networkdays formula between today and go live date
Hi, I would like a formula to calculate the number of network days between todays date and a go live date and return a negative if go live is in past and positive if go live is in future eg todays date 24/03/25, (go live date) 29/03/25 = 5 days Here is the formula im currently using =TODAY() - [Requested Go-Live]@row on my…
-
Override Column Formula for Particular Cells
It would be great if we could edit single cells within a column that has a column formula in place without having to convert it back to a Cell Formula! That way if we have accurate data for one cell, we can change it and still keep the formula for the rest of the column!
-
LOOKUP addresses and format as CONTACTS
I have a working formula =JOIN(COLLECT({EMAIL}, {AGENCY}, Agency@row), CHAR(10)) This gives me all the emails for an agency in a single cell, with a return between each address. I need to transfer the grouped emails to another sheet in a CONTACT COLUMN and have them recognised as contacts so that I can set a filter in…
-
Help with Countifs and not contains formula - no longer working
I have been calculating how many submissions in a month in one column (column A), and cross-referencing against another (column B), to ensure I'm not counting items that have a particular word in column B. I used the AI help (when it was available) and the following was working: =COUNTIFS([Date Received]:[Date Received],…
-
Countifs off by one
I am trying to get a count for a date range, but am getting a number that is one less compared to the filter. Current Tuesday Formula: =IFERROR(TODAY() + (3 - WEEKDAY(TODAY())) - IF(OR(WEEKDAY(TODAY()) = 1, WEEKDAY(TODAY()) = 2), 7, 0), "") Previous Tuesday Formula: =IFERROR(TODAY() - 7 + (3 - WEEKDAY(TODAY() - 7)) -…
-
Force upper case on a column
Hello Everyone, I got a question. Is there any way to force upper case on a text column? I have a column where users enter information using iPads and it will be very helpful if the cells will automatically force to have upper case font in it. Thanks
-
UPPER formulas
Is there a way to set a formula so all text in the column or sheet is upper case even if someone enters it on a form in lower or title case?
-
Allow Gantt view to use Date columns with Column Formulas for Start/End
I'm kind of flabbergasted that this is not currently possible in a Sheet, and I'm struggling to explain to my users why. It is already possible to populate a Date column with a Column Formula and then convert it to a Cell Formula, and then use that column as the Start/End for Gantt view / Project Settings, so the issue is…
-
Elapsed time from a system column to the current datetime
Hi guys, I need some help to calculate the hours and minutes have elapsed from a system column (which is the ticket creation date) to the present date, not sure if it is possible to use TODAY() formula. Here are some screenshots of what I have so far, but seems like the minutes calculation is not working. The ultimate goal…