-
SUMIFS with multiple criteria and date range
Hi, I am struggling in getting the following formula to work. =SUMIFS({P-CARD Range 1}, {P-CARD Range 3}, AND(@cell>=DATE (2025, 1, 1), @cell<=(2025,12, 31)), {P-CARD Range 2}, [15]150) Range 1 = is a column with dollar values. Range 3 = is a column with date values. Range 2 = is a column with specific classification…
-
Formula error
What is wrong with my formula? =COUNTIFS({MBF Open SB Range 3}, "737", {MBF Open SB Range 4}, "top kit") I made sure that the column with "737" and "top kit" are both text/numbers but im still getting 0 as total
-
CountifS with Distinct
I need a function to count how many time a territory as unique SIDs in a sheet. I tried the function below but it won't work. =COUNTIFS({Total URV Visits Range SID}, DISTINCT({Total URV Visits Range SID}), {Total URV Visits BEC}, District@row)
-
Allow User to Expand the Text Box for Customize Messages in Automations
Please add the ability to expand the text box when writing text for a customized message that is part of an automation. In most software, this means an option to click on the bottom right corner of the box and drag it out to expand it. It is helpful to see the entire message when drafting it, and later when reviewing or…
-
Filter on cell value
A filter option to filter on the value of the selected cell. I believe the correct term is 'Filter on Value'. The right click filter feature will return all of the rows in that column that has the same value as the cell that is selected. Thank you.
-
Sheet - Format Cell Border
The ability to format cell borders with line style and color.
-
Expand and/or notify of character limit in drop-down values
Unless I'm missing the information, it would be nice if there was some pop-up message that indicated that a character limit has been exceeded when creating drop-down values; and/or the character limit could be expanded above 100; background is I (and others) spent lots of hours trying to figure out why some of my drop-down…
-
Automation to send separate notifications per row when a date is reached
It would be helpful if there was an automation that will send one row per notification, when a date is reached, with attachments. For example, if I have a sheet that has orders that need to be placed, and a column on each row for the date that I would like the orders to be sent. Currently, the automation to "Remind someone…
-
Drop down options character limits
Is there a limit to the amount of characters for each drop down option? it appears to be around 40 characters and its pushing the text over to the next line.
-
Custom View for Calendar App
Is there a way to have custom views based on a group or individual identified in a column similar to the 'Current User' filter for reports?
