-
How to calculate the % of complete activities under each parent row.
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?
-
Contact List, with Upates
I've searched and can't find a solution in the community. New staff members complete a form which includes providing an email address. The email is saved in a Contact List column. So far, so good. Once they are hired and in the HR system, the receive a Net ID, which when combined with the university domain, is their…
-
Formulas for Sheet to Sheet Summary to Dashboard
I'm officially stumped. I'm tracking Admissions Reps visits to schools, the types of visits and the amount of visits and inquiries. The columns are as follows: Created Date Rep Name Type of Event 1 - Dropdown: Tabletop, College Fair, Classroom Presentation, School Visit, School Tour District 1 - Dropdown with all Districts…
-
Formula Error multiple criteria
Hello, I am trying to find the average audit score for a range of percentages between two dates. There are divider rows for organization by month. I have been trying to utilize the following formula but continue to get #DIVIDE BY ZERO for an answer: =AVG(COLLECT([Audit Score]:[Audit Score], [Date of Chat]:[Date of Chat],…
-
Multiplying the Values of My Ancestors
Hello, has anyone found a way to multiply the values of the Ancestors for a specific cell together? For example, I'm trying to get the total amount of 31445A113 required for the assembly A-341-10-1-0999. I was hoping to just use the Ancestors formula to multiply the quantity for A-341-10-1-0999 (x2) but the quantity for…
-
Formula to remove the 'd' from "Days Needed" rollup number relinked into my summary Sheet?
Hello! My company needs to determine how many Total/Average days it is taking our team to complete our projects. We use Smartsheet Project Schedules. And at the top of each project schedule is a 'Days Needed' roll-up. In a separate sheet, I am adding/cell linking all of these 'Day Needed' roll-ups. In this separate sheet,…
-
How to Tally Days with an Date Entries
I have a form set up for people to enter their CHECK-IN and CHECK-OUT dates. I'm looking for a way to have the dates tallied for all reservations received. So for row 1 - a "1" would enter under 7/21, 7/22, 7/23 and 7/24. And for row 2 - "1" would enter in 7/21, 7/22, 7/23. etc. to 7/26. Is there a way to do this so I…
-
How do I limit the number of entries under the same company name
I have a list of companies that are allowed 2 complimentary registrations. I want a notification sent if a third registration is added that tell the company rep they need to pay for the third registration. I have a list of company names with the contact information. I then have the registration list with a form for…
-
Reconciling events and transactions
I have two sheets, one with data about events and then other with financial transactions. The events are added as they are reserved, possibly months in advance. The transactions are copied from our accounting system each month and have a lot of data but primarily, some descriptive details (to ID which event it was for),…
-
Conditional Formatting
Hi all, and thanks in advance. I was trying to do a Conditional Format on this. I know how to do it in Excel, as I would use a formula, but I am having trouble with only the dropdown choices available. Okay, I want my CF to check if the 2 circled columns are the same. This instance does not show, however basically I am…