-
Phone number Cell Format like Excel phone number cell Format
I can not for the life of me find where I can format cells for Phone numbers like excel. I'm having people enter in their info via a form and the phone numbers are causing immense discrepancies. Is there a way to format a column for phone numbers or selection on a form for phone number like there is for a date?
-
Incremental Budget Forecasting based on Monthly Due Date Percentages
In excel, we have two sheets: Sheet 1 - A percentage breakdown per country based on historical data for each Month prior or after the Due Date month. Zero = Month Due Date. -1 = the Month prior to the Due Date Month, etc. Sheet 2 - For Country, Due Date and Projected Total Spend, we calculate (via formulas) the Current…
-
Linking another sheet within a formula
If I link another sheet's cell within a formula and I copy that formula horizontally, will the linked cell in the other sheet move accordingly?
-
Return last workday
Hi, I'm trying to create a report that will display the items for the previous work day. I initially tried creating a helper column with the following formula =IF(Date@row = TODAY(-1), 1, 0) which works great for Tuesday through Friday but on Mondays, it returns for Sunday. Is there a way to have it return the last weekday…
-
Calculating this week's revenue based on probability, hourly charge, and hours consumed.
I'm creating a sheet that shows my leadership a future week's revenue based on the following formula: = hours x rate x probability of sale going through This calculation get's complicated if the sales goes through in the middle of the week (e.g. Wednesday) because I'd have to do a calculation that takes a fraction of the…
-
COUNTIFS to find unique values across two multi select dropdown columns?
Hi all, I'm looking for some help with a formula that will do the following (see screenshot): for every different "Person x" that appears in the Names column (multi select dropdown), count the total number of unique items that appear on rows wherever Person x is listed. Items are in another multi select dropdown column.…
-
Dashboard Widget Chart Issue with Multi Select
I have a dashboard chart widget that was pulling data from a single select option. I've now changed it to multi-select but I see that my chart isn't pulling in that item at all when there are more than 1 item selected. Am I missing something? Is there a formula that I can use to pull in that single option + any combination…
-
Countif formula
I would like to count the number of children cells that contain dates in February or March 2016. How do a formalize the criterion to select cells with dates in February 2016 and March 2016?
-
Create a Cell that can summarize what's missing in other cells of the same line?
Hi! Sorry in advance, I may over-write / overexplain because 1. I'm lame at explaining and 2. English is not my first language ^^' In my work, I need to do a release checklist, with multiple checks. Each check is a cell saying for example "Date OK?", or "Price in database?" etc etc. I fill this cell with "OK" if it's done,…
-
Nested IF with Children
Greetings, I'm attempting to configure an Epic (parent) field to automatically change based on the statuses of the child fields. For example, the criteria I'm attempting to meet is: If all child status fields are in "To Do" then parent field status is "To Do" else "In Progress" If all child status fields are in "Done" Then…