-
Forms and Formulas - Form add a row to top but formula does not include
I have a smartsheet that I want to use for team holiday requests.The team would fill in a form that add their request to the top of the smartsheet. Further down the smartsheet is a summary, by team member, of their total holiday allowance, calculated by formula of the number of days requested (and approved) and number of…
-
How to count the number of children based on certain value of parent
The column name is [Task] and a cell value called "Project Details" is located somewhere in the column. Their children is project 1, project2, ... etc.... I want to count the number of children under "Project Details". I know that if the position of the cell "Project Details" is fixed. I can use formula like this:…
-
About the approval request for spesific people
hey everyone, i want to ask about the "approval request automation". i have project that need some approval request for the spesific people. for example, in my organization, i have 2 Divison Manager, which is a different person. so, i create the approval request by the trigger with Division 01, and Division 02. But the…
-
Does Smartsheet have a way of showing hours spent working within the account?
I work at a manufacturing company & have implemented Smartsheet to be used within every department. Right now I am currently the only admin who creates and/or updates the sheets, reports & dashboards etc. We have over 300 active sheets. Needless to say, it has become a full time job all by itself. Unfortunately, I also…
-
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…
