-
I am trying to send multiple rows ina automation alert
I have attempted multiple strategies to send multiple rows based on a trigger. The automation only sends the row where the trigger event occurs. Below is the Automation logic, The email that was sent and the data in the sheet.
-
Placeholders | Still batching Emails
Hi team, I'm using Placeholders in a workflow to generate individual emails for an update request. Although the same individual received the update, they will forward as needed, so I need to ensure each update request for the day doesn't 'batch'. I've done a small test and had no issues, but when i moved into the live…
-
Use Modified Date to show when the last time a sheet was edited.
I would like to enter a formula into Sheet Summary that will show the last time a sheet was edited by a specific person. That person is identified on every row in an "Assigned To" column. I have both the Modified and Modified By columns on my sheet. Somebody started helping me with this, but kinda trailed off. I understand…
-
Log of user access to sheets
In the Control Center, I create a group of files each time a new project is started. I am being asked to create a report/sheet/dashboard that shows the date of the last time the project manager viewed/edited the sheet. If successful, this will show information on 20-25 projects, so automating the solution as much as…
-
Best Practices Help - Form initiated workflow with 3 regional spin-off sheets
New user looking for some advice. We need to: Capture requests from a form(s) and save the original data. We know comments and attachments will be made by other users, and we don't want them to mess up what was originally there, or the original data in other rows put in by other users. We will have 3 regions that will…
-
Why can't I create a folder in a Workspace I am assigned to edit when I have a Full License?
Basically that. I have been assigned to Edit several Workspaces, and have been given a full Smartsheets License, but I still cannot create folders in Workspaces. Does anyone know how to correct this or what access I would need to a Workspace in order to create folders in it?
-
averageif with multiple criteria
I am trying to find the average of time in position (demographics range 1)when the job class (demographics range 3) is manager or higher. I'm currently using =avg(collect to try to specify the multiple criteria but am getting a #divide by zero error message. I have my formula written as =AVG(COLLECT({Demographics Range 1},…
-
Need a formula for counting information based on date
Hello, I need a formula that can help me calculate the sum within a column based on date. Not sure if this can be achieved. We are updating information on a weekly basis and I have different rows for the same date. I need a formula to give me the sum based on the date. For example, on 1/17 I will have 6 rows with data that…
-
Editors cannot overwrite cells with formulas
Hi there, In a sheet I've few cells that have formulas, columns were those cells are aren't lock, however the users cannot overwrite the formulas, any idea why it may happen? The idea was to create formulas as a guidance but editors should be able to overwrite them, in this case isn't happening, they cannot enter values in…
-
Sheet Summary Formula for Due Dates
Hello, I have two separate column Status and Due Date and I'm looking to create a formula on the sheet summary for the amount of items that are due today and past due. Is there a way to create one?