-
Email Notifications
Assume i created a new sheet and added email ids of my resources into a column X in smart sheet where the column X is assigned as contact column. I have created a workflow where any changes to the rows on other columns in the SS, should trigger an email notification to the assigned email id of the updated row from theβ¦
-
Auto Email Form Responses
I am wanting to have completed forms auto emailed to an email address that will be supplied in one of the fields on the form that is not the submitters email. Does anyone know if there is a way to do this? I didn't know if this could be done via a workflow but essentially I want the nominated email to received a copy ofβ¦
-
Automation Notifications
I am struggling with the new Automation Notifications as I found the previous arrangement much easier to set up for simple alerts and notifications. I want to set up a daily notification that gives me only new comments that have been added to a sheet. At the moment I seem to have to get all the attachments, all the sheetβ¦
-
Linking row data together into new sheet.
Hi All! So I have a sheet with a list of tasks, their due dates and a checkbox column for when they are completed. I'm trying to set up some formulas in another sheet (my metrics sheet which feeds to a dashboard) toΒ generate a top 5 overdue tasks list by searching the list for the most overdue dates. I've managed to getβ¦
-
Sheet Summary Report Builder only shows the system columns
I am trying to create an aggregated view of data from multiple sheets using the "Sheet Summary Report" but when get to the Builder, it only shows the system columns for display. Obviously this is not helpful if I cannot merge together data from columns other than the system columns. Am I doing something wrong?Β
-
Problem Saving Blueprint
Hello Smartsheet, I'm hoping that you can assist me. I've added a new sheet to my Blueprint (I've done this before). The sheet has one profile field (Project Name). I don't need anything on the sheet to report out to anywhere. When I try to save my Blueprint, I receive an error "add more column(s) to reporting sheet". I'veβ¦
-
Using SUM function on a column that has IF formulas in the cells
Hoping someone can help me with this issue! Please see the attached screenshot. I'm having this issue on 4 columns but will use the "Visit Metric" column as an example. I want to SUM the values of all the cells in that column within a cell at the bottom of the sheet, =sum([Visit Metric]2:[Visit Metric]114). However, when Iβ¦
-
Cross Sheet Formulas For Children Rows
Hello. IΒ΄ve spent all day trying to look for how to do this, I found some info but wasnΒ΄t exactly what I needed, plus, IΒ΄m new using smartsheet. What I need is to bring info from another sheet, but only what is inside a children row. I have a budget sheet with several ancestor, parentΒ and children rows; I need to useβ¦
-
JOIN/COLLECT/IF statement
Has anyone used a JOIN/COLLECT statement within an IF statement? Specifically, I want to join and collect responses across multiple rows where a column in the sheet has a specific value. See the example, where I have data in a source data sheet that I'm trying to summarize on another sheet. Not even sure if JOIN/COLLECT isβ¦
-
Number formatting in Sheet Summary
Hello all, I'm using sheet summary to get rid of the top row on our master project list.Β Formerly, we used "=SUM(CHILDREN())" to add up all projects & sub tasks.The top row was only there to add everything up. We moved this functionΒ over to the Sheet Summary & it's working fine. My issue is the number formatting. Theβ¦
