-
Update one sheet using Power Automate on several Excel files?
Hi there, I have a use case where I have a bot creating Excel files daily. I'd like to use Power Automate to tak the data from those Excel files and add it as rows into an existing sheet in Smartsheet so that I can add workflows to the data in those rows. I tried setting up a flow in Power Automate, but was stuck on two…
-
Report Creation tool within a sheet
One of my most frequent uses of Smartsheet is as an editorial calendar for a weekly newsletter. I create a new sheet for every month of the year. Exiting a sheet and creating a report is not too much of a hassle but, it would be nice if I could click a button within a sheet that automatically opens a new page that is a…
-
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…