-
Find previous date for then calculate days between dates
Hi all, I'm having difficulty creating a column that shows the number of days between jobs at the specific venue. Sheet is essentially a list of jobs at various venues. VENUE A, 02/02/23 VENUE B, 10/02/23 VENUE C, 15/02/23 VENUE A, 16/02/23 The column I'd like to create would show the last row for VENUE A as 14 days. I'd…
-
Is there a way to restrict number input to positive numbers only in a form?
I'm building an approval process/workflow for a finance team and I'm curious if there is a way to restrict number inputs to positive numbers only?
-
Pulling "Assigned" Tasks into one sheet
Does anyone know how to pull tasks assigned to you from one sheet into another sheet?
-
UNPARSEABLE IF AND MAX FORMULA HELP
Hi Community, Can you tell me what is wrong with this formula? If the automatically populated created date is Max it returns 1 if not 0. =IF(Created@row ={MAX}Created:Created),1,0)
-
Searching within a large dropdown list
Hello, I currently have an expense report for our company credit cards. On the expense report I have a drop down that lists all of the account numbers so that each line item can be posted to the correct account. There are hundreds of accounts and I would like to know if there is a way to broaden the search within the drop…
-
Move a row but only some columns
Hello I am trying to to split a row from a form entry and send 3 columns of that row to another sheet but not the rest of the row. Is there any way to do this without any add-ons? I cant have any vlookup or Index/match on the destination sheet so I have been trying to use a helper sheet but as soon as the first row is…
-
Allow Send as Attachment Within WorkApps
Allow users to set a Send as Attachment within WorkApps. I've given permissions only via WorkApps and would like the user to be able to get the attachment without having to be shared to the actual sheet or report.
-
Contact type column across multiple sheets
I have a list of contractors that is constantly being updated, from when they are on-boarded, to when they are deactivated. I would like them to be entered as a contact type column. I have multiple sheets where I want this column to be identicle, and also want that when I update Sheet A and add a new contractor and their…
-
Dependant dropdown lists
Hi. Is it possible to create a dorpdown list that is dependent on the option selected in other column. For example, when I have list of 300 Banks with SWIFT codes . One column is Bank name, another column is SWIFT code. I also have a list of vendors and need to choose in vendor form their bank account. I write vendor name…
-
Is it possible to get rows automatically sorted in a sheet as new rows are added?
I have several sheets where it would be incredibly useful for them to automatically sort as new rows get added & cells change. Is there a workflow I can set up to do this so it automatically sorts on some kind of timeline (daily, weekly, etc.)?
