-
Formula to check box if cell contains Date OR Text
I have a nested formula that currently involves one check box be checked and three date columns to contain dates in order to check-mark as 'Complete.' However, I discovered one of the date columns involved may contain text from time to time (as a date is not always applicable to this particular field). How can I revise my…
-
INDEX/Match Error?
Hello, I have the following Equation written out: =INDEX({Brand Manager}, MATCH([Brand Channel]@row, {Brand Channel}), 0) {Brand Manager} and {Brand Channel} are pulling from Sheet A. Brand Channel is a column that is in Sheet A and Sheet B. The equation is written in Sheet B. My expectation of the equation was to pull in…
-
Merged: Checkbox column SUM summary in Reports
This discussion has been merged.
-
Formula to always Summarize all 5 cells to the right of a column, including new columns added.
Hi, Is there any formula that can return the summary of any of the 5 columns to the right of this column layout, no matter what columns are inserted from there on? I keep on adding columns, but I want it to always calculate the columns that are now (or in the future) within 5 columns to the right. Thank you,
-
Can you generate a date with limits?
I am working within a tracker, and I have the date autogenerating. Currently the date will generate once the first update will occur, and I just did =[Review Date]@row + 60 so that it adds 60 days from the review date. However, the program ends 12/31 so I want to add a limit so that if 60 days from the review date is after…
-
Approved Domain Sharing
Hi all, As an Admin I would like to run a report to establish what external users have been given access to our content. All external users have to be in the approved domain sharing list, however what are they accessing? Thanks Gavin
-
Dashboard Notifications
Hi, I set - up a dashboard recently for a client and would now like to automate updates to be sent to the client via email when changes are made to the dashboard. i.e. when a new link is added. Is this possible yet? I understand you can do this on sheets already. Thanks
-
% Complete Formula based on Start/Finish Dates
Hello! I am in need of help writing a formula to auto-calculate the "% Complete" column based on the "Start" column date and "Finish" column date. Additionally, I also have an auto column for "Duration". The goal is to have the % Complete auto calculate based on the today's date in relation to the start and finish date…
-
Date formula for Last month, Last Quarter, Last year
I'm looking to add some formula to my summary sheet and the requirement is for analytics for Last month, last quarter and last year - so excluding current month Examples if: current month = May 2020 last month = April 2020 last quarter = February, March & April 2020 last year = May 2019 to April 2020 inclusive These would…
-
ActiveCell References, COLUMN and ROW Functions
I want to make a sheet summary field return whatever is in row 6 of the activecell's column. It has to dynamically change with the cell's position. Similarly, based upon the activecell's row, I want to return the value of Column 2 of that row. Excel has a feature for ActiveCell which then you can use Offset or Index to…
