-
Can I add a specific row to an email from a workflow?
I have a smartsheet and there I will let people know when certain tasks have been executed. I have already created the workflow for that. My issue is when sending the email; can I add one row only on the email to notify that a certain task has been executed, so when I change one cell from "In Progress" to "Executed" a…
-
ABSOLUTE CELL LINKING
Im really struggling with getting an absolute cell value to stay in a sheet or in a sheet summary. maybe im going at in the wrong direction. please help. I have a form on my call centre data sheet that is adding an information line each day. The line is picking up all my formulas for my metrics on who is answering the…
-
At Risk Formula Update
Currently using the Onboarding Template Set and in the Sheet Onboarding timeline, I have the Risk flag set, the current formula is to flag if the end date is in the past and the status is not compete (for the row)formula is =IF(AND([End Date]9 < TODAY(), NOT(Status9 = "Complete")), 1, 0) but I need to update it because I…
-
Formula to record attendance using check boxes and flag the row if missing meetings?
I am new to SmartSheet and need assistance creating a formula or function to make it easier to to keep up with attendance for meetings once a month. Any one person from the group can attend and as long as one person does, the entire group gets credit. I would like to use a function which will give me a quick indicator that…
-
Sum Children formula
Hi all. I am having an issue with getting a correct sum from children of a parent row when using a formula in the children rows. Ex: Children row formula is =IF([Date Completed]43 > [Due Date]43, "1", "0") There are two children rows; the formula above creates a 1 and a 0 respectively, however, my =SUM(CHILDREN()) formula…
-
Email recipients from automation
Is there a way to view the recipients of automation email when you have Editor access to a sheet?
-
Advice: Looking to create a Global Onboarding SmartSheet
Currently our organization uses 3 separate sheets (one for each region) to track the status of onboarding our new hires. We capture things like: New Hire's Name, Start Date, who the offer letter was assigned to, when the OL was created, Drug Screen information, Background check information, etc. I would like to combine all…
-
sort in report
i have a repotr based on sheet with ~1500 rows (parents and children). as i know there is no way to show the parent and children in repost so that i mark in color the parent and sort the report to show the parent and children. but, now i want to sort with another level: i want to show in report the parents row and…
-
Counting open tickets based on company name and ticket status
Hi, I'm trying to count the number of open tickets by company name, and the cells I'm referencing are in another sheet. Here's my formula so far: =IF({Maintenance tracking Sheet Range 2} = [Company Name]@row, COUNTIF({Maintenance tracking Sheet Range 3}, {Maintenance tracking Sheet Range 3} = "Open")) But I'm getting an…
-
Convert Symbols to Numerical values
What is the formula to convert the bar symbols of Empty, Quarter, Half, Three Quarter, Full to numbers? For example, Empty = 0 Quarter = 1 Half = 2 Three Quarter = 3 Full = 4