-
How to I indent/outdent tasks in the Task List view?
Hi, I'm new to Smartsheet - I have created a Task list and want to create parent and child rows in a task list, but the indent/outdent buttons are shaded out and the shortcuts (Ctrl ] ) don't do anything. Can you only create hierarchies in a Project?
-
One SmartSheet - Five Separate Forms - Possible Overwritten? How can I retrieve old forms data?
Hi there, Is there a way to retrieve old form data and have the output into a new smartsheet? The information may have been deleted or overwritten with each new iteration of the form as the new information was not added or archived. But the forms are still there with the amount of responses. Please help!
-
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…
