-
Calendar functionality
Is there a way to make a recurring event for weekly or monthly easily? I know that I can copy and past into the grid and change the dates but I'd rather use a recurring function. For example, a Saturday market that occurs every Saturday until October. I'd like to add the first date (may 14th) and then set it recurring…
-
Count Cells that begin with a specific text
I wanted to COUNTIF the number of cells that start with specific four letters in a column of a reference sheet. I used the formula below and it returns zero. =COUNTIF({Reference Sheet}, "ABCD") Is there a formula to return the number of cells that have the first four letters as "ABCD"?
-
Combining Formulas to make one big Formula
I currently have all the individuals formulas i'm looking for however I'm having trouble combining them into one formula that I can embed in a cell. I know I can create a workflow automation to get the result I want however I enjoy the rapidness of using an embedded formula. Does anyone know if it's possible to combine the…
-
How can use a field several times within a form?
Hi. I need to collect feedback about several programs using a form. The form should include the same questions for each program. Any ideas about workarounds that allow me to use a field several times within a form? I want users to receive one form to collect their feedback about the different programs.
-
How can I display the most recent entry from a grid sheet in a dashboard widget?
I have a grid sheet which captures status date and status narrative text as columns. For each new status date, a new row is added to the grid sheet. How can I display the most recent status narrative text in a dashboard widget?
-
How do I unshare individual sheets in a Workspace?
I need to share a workspace with some users with the exception of a few sheets that have confidential information. Is there a way to share everything except those sheets? There doesn't seem to be a way to do that without removing workspace access and then resharing every other sheet, report, dashboard, etc. manually. I'm…
-
COUNTIF(AND) FUNCTION
Hi again, I am trying to write the following formula and am not getting the answer I am looking for. My goal is to count the late items in a task sheet. This require two parameters to be met. the date is in the past the progress status is not "Complete" =COUNTIF(AND({Due Date Range}, <TODAY(), {Progress Range},…
-
Averageifs Question
Hello! I am wanting to do an averageifs statement, but it does not seem that is supported. Is there another way that I can calculate an average based off fitting two different criteria? Right now, I have this equation, which works for when just hitting the one criteria: =ROUND(AVERAGEIF({System Request}, [Ticket Type 2]1,…
-
Viewing Submitted Forms
Good morning, I'm creating a form that I'd like to be able to save the responses as a PDF document. As far as I can tell, the only way to see submitted forms is through the sheet itself - not in any "document" format that could be easily saved to a DMS. Is there a method to show submitted form data in a way that would…
-
What happens to my automation if I run out of rows?
Hey there! I am working with a large archival destination sheet: We haven't hit 20k rows YET, but it'll probably be coming this year. The automation moves Completed rows from an active tracking sheet to the archive sheet- we keep that for a full accounting of these completed processes. But.... what happens when…
